Hi all,

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);
GROUP BY links.iwork;
INTO CURSOR Linked

SELECT Exhibit.iid, Exhibit.nkey, linked.*;
FROM Exhibit LEFT OUTER JOIN Linked ON Exhibit.iid =Linked.iwork

Any help would be greatly appreciated.