Russel,

Think you'll need two queries

SELECT c.jobno,a.drwno,c.lastrev,a.revno,b.date AS trdate,a.transno ;
FROM issuehistory a ;
	LEFT JOIN transmittallog b ;
		ON a.transno = b.transno ;
	LEFT JOIN drawinglog c ;	
		ON ALLTRIM(a.drwno)==ALLTRIM(c.drwno) ;
INTO CURSOR curPrint_1 NoFilter ;
WHERE !DELETED() AND (ALLTRIM(b.iscode)=='A' OR ALLTRIM(b.iscode)=='B') ;
ORDER BY c.jobno,sort1,sort2,sort3


select *, ;
       (recno()=1) as First ;
    from curPrint_1 ;
    into cursor curPrint

>I have the following SQL statement:
>
>

>SELECT c.jobno,a.drwno,c.lastrev,a.revno,b.date AS trdate,a.transno ;
>FROM issuehistory a ;
>	LEFT JOIN transmittallog b ;
>		ON a.transno = b.transno ;
>	LEFT JOIN drawinglog c ;	
>		ON ALLTRIM(a.drwno)==ALLTRIM(c.drwno) ;
>INTO CURSOR curPrint ;
>WHERE !DELETED() AND (ALLTRIM(b.iscode)=='A' OR ALLTRIM(b.iscode)=='B') ;
>ORDER BY c.jobno,sort1,sort2,sort3
>
>

>
>This returns the following:
>
>

>Jobno      Drwno     Lastrev     Revno    Trdate     Transno
>6037       E101A        C         0     01/17/2003    58995
>6037       E101A        C         0     01/24/2003    59159
>6037       E101A        C         A     02/10/2003    59352
>6037         1          B         0     01/17/2003    58995
>6037         1          B         A     01/24/2003    59159
>...
>

>
>Is there a way to tag the first instance of a drawing number? Something like below:
>
>

>Jobno      Drwno     Lastrev     Revno    Trdate     Transno   First
>6037       E101A        C         0     01/17/2003    58995      .T.
>6037       E101A        C         0     01/24/2003    59159      .F.
>6037       E101A        C         A     02/10/2003    59352      .F.
>6037         1          B         0     01/17/2003    58995      .T.
>6037         1          B         A     01/24/2003    59159      .F.
>...
>

>
>Any help would be greatly appreciated.
>
>Thanks in advance.