I have 3 tables (simplified):
Invoice Header
Invoice_No
Vendor
Invoice_Detail
Invoice_No
Item_No
Item Desc
Vendor
Item_No
Item_Description
I'm trying to find any Item_No in Invoice_Detail that does not have an Item_Description in Item_Desc. When I construct the query to join Invoice_Header.Vendor to Item_Desc.Vendor, Invoice_Header.Invoice_No to Invoice_Detail.Invoice_No and Invoice_Detail.Item_No to Item_Desc.Item_No where Item_Desc.Item_Description is null I get an error about ambiguous outer joins and to create a separate query to perform the first join, then include that uery in my SQL statement. I have no idea how to do this! Can anyone help?