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.
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.
