Hi, I'm having a problem when selecting data from a table where there are rows where no data exists.
I'm searching through a list of locations to display whats in them, but if the locations are empty then the location is not displayed on the report output. i.e. it only displays rows where there is something in the location.
I need to display even the empty locations and can't find a way of doing this and would really appreciate some help.
Here is the code I am using:
FROM Table1, Table2
WHERE Table2.List_ID = '&1' AND
((Table1.Location_ID = Table2.Location_ID) OR
(Table1.Location_ID IS NULL) OR
(Table2.Location_ID IS NULL)) AND
((Table2.Sku_ID = Table1.Sku_ID) OR
(Table1.Sku_ID IS NULL) OR (Table2.Sku_ID IS NULL)) AND
((Table1.Tag_ID = Table2.Tag_ID) OR
(Table1.Tag_ID IS NULL) OR
(Table2.Tag_ID IS NULL))
GROUP BY Table1.Location_Id, Table1.Qty_On_Hand, Table1.Sku_ID, Table1.Description, Table1.Tag_ID, Table1.Batch_ID, Table1.Condition_ID, Table1.Config_ID;