Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Join

Status
Not open for further replies.
EscapeUK

EscapeUK

Programmer
Jul 7, 2000
438
GB
How can I join to a table if a value in one of them does not exist. Eg If in my main table I have a value 0.

I would like to get the description for the item the user enters in a query plus all the ones where the value is 0.

My join does not work because in the table containing all the descriptions there is no record with the ID as 0/

There thats clear as mud.
 
Sort by date Sort by votes
Double click the join line in the query and change the join type to include ALL records from the table with the '0's and only those matching from the other table.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
235
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
282
dhookom
dhookom
PeDa
  • Locked
  • Question
Join on table1.var1 = -table2.var2 gives 'Join expression not supported' error
Replies
9
Views
211
combo
combo
JeremyNYC
  • Locked
  • Question
Trouble with Left Join
Replies
1
Views
124
JeremyNYC
JeremyNYC
serino
  • Locked
  • Question
Help with INNER JOIN error 1
Replies
7
Views
123
serino
serino

Part and Inventory Search

Sponsor

Back
Top