I'm new to sub-queries and I was wondering if it was possible to combine the following into one select statement using a sub-query.
Select * ;
FROM Links;
WHERE Links.itype in (1,0);
GROUPBY links.iwork;
INTOCURSORLinkedSELECT Exhibit.iid, Exhibit.nkey, linked.*;
FROM Exhibit LEFTOUTERJOINLinkedON Exhibit.iid =Linked.iwork