>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 >>
select Exhibit.iid, ; Exhibit.nkey, ; L1.* ; from Exhibit, Links L1 ; where ( Exhibit.iid ; in ( select Distinct L2.iwork ; from Links L2 ; where ( L2.itype in (0,1) ) ; ) ; ) ; and ( Exhibit.iid == L1.iWork )