On 7/12/2000 2:15 PM, Brad Jones supposedly said:

>I'm attempting to grab a variable number of records off the top of an

>ordered SQL-Select statement. Everything else about the SELECT statement

>will be the same.

Use parentheses.

SELE TOP (parenttable.nQty) ;

fld1, fld2, fld3 ;

FROM childtable ;

ORDER BY 1

___/

/

__/

/

____/

Ed Leafe

http://leafe.com/