G
Gary Dolliver
Hi all,
I currently have 3 tables (order, creations, items) that I would like to
check and see if there are corresponding records in each. For example, I
would like to check and see if there are items for a specific order in the
items table, or the creations table. Is there a way I could have it show a
result set of all the orders that do not have a creation, or do not have an
item? the linking fields are Order_ID, Creation_ID, and Item_ID - how would
i set this up?
please help, thanks!
-gary
I currently have 3 tables (order, creations, items) that I would like to
check and see if there are corresponding records in each. For example, I
would like to check and see if there are items for a specific order in the
items table, or the creations table. Is there a way I could have it show a
result set of all the orders that do not have a creation, or do not have an
item? the linking fields are Order_ID, Creation_ID, and Item_ID - how would
i set this up?
please help, thanks!
-gary