5 : FROM FIELDS INNER JOIN LOOKUP ON (FIELDS.CATCODE = LOOKUP.CODEVALUE) AND (FIELDS.PUBYEAR = LOOKUP.PUBYEAR)
6 :
7 : WHERE (((FIELDS.PUBYEAR)=#pubyear#) AND ((FIELDS.RANK)='Y'))
8 : GROUP BY LOOKUP.CODEDESC,LOOKUP.CODESEQ
9 : ORDER BY LOOKUP.CODESEQ
|