question

Prime257 avatar image
Prime257 asked

Get all the values where a column is null through join

Hi,

I am trying to create a bridge table in SQL and want to join back to the lookup table.

what I want to achieve here is if I join on the Hierarchy code and Base code I am getting the desired result, But I want to get all values in the lookup table for each hierarchy code where the base code is null in the bridge table.

sql
test-tables.jpg (26.9 KiB)
test-tables.jpg (26.9 KiB)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

You don't have to use a join - is there any reason why you are asking for that method?

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.