Is it possible to use the result of a sql query as a lookup for an additional query, but doing in just one query.
That sounds confusing
eg
I lookup records with ID of 10.
It returns 3 results.
Each of the 3 records has another ID number in a field, eg 11, 12 and 13.
Could I then lookup all of the records with ID of 11, 12 and 13?
So altogther I have records with IDs of 10, 11, 12 or 13.
Is that possible using just one query? Or would I have to use more than one?
EDIT: I managed to do it in the end, I had to use subqueries.
/ 
