Orphan Records (Joined tables)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Given this setup:



I want a list of item descriptions which do NOT have an inventory
record. Any ideas? I did this before in MS Access as I recall by making
a query of things with inventory only then excluding those but I can't
even recall how to do that now. I'm working with php/mysql now and had
some luck generating aql with Access but not for this one.

Re: Orphan Records (Joined tables)

paul wrote:

Quoted text here. Click to load it

I got it (pretty simple in access and works on mysql):

SELECT plants.plantID, description.latin_name
FROM description LEFT JOIN plants ON description.id = plants.description_id
WHERE (((plants.plantID) Is Null));

Site Timeline