Select Exhibit.iid, Exhibit.nkey, Links.* ; FROM Links; LEFT OUTER JOIN Links ; ON Exhibit.iid = Links.iwork ; WHERE Links.itype in (1,0); GROUP BY links.iwork; INTO CURSOR Linked