First off I am using Access.
I have a simple query where I need the Information from 2 fields, I know hoe to get the first bit of data but not the second.
First I need the Distinct ParentID's from the table Items:
This Gives me a recordset of 0, 5, 11.Code:SELECT DISTINCT ParentID FROM Items
Next I need the data in the Name field based on these ParentID's. Is there a way to do this with out doing 2 queries?