Ranking..(RecNo.)

V

Viju

Hi,
I am posting a query as a continuation of the query
posted on Sunday, 14 Sep 2003 regarding RecNo().

SELECT INVOICEITEM.INVOICENO, INVOICEITEM.ITEMCODE,
ITEMMASTER.ITEMNAME, INVOICEITEM.QUANTITY,
INVOICEITEM.COSTPRICE, INVOICEITEM.SALEPRICE
FROM INVOICEITEM INNER JOIN ITEMMASTER ON
INVOICEITEM.ITEMCODE = ITEMMASTER.ITEMCODE
WHERE (((INVOICEITEM.INVOICENO)='26'));

Now I wanted to include a column which will
display 'SlNo'. It is not necessary to order the rows.

Thanking you in advance,
VIJU
 
Top