Which reminds me... I tried that one too; also to no avail.

Thanks though!

I feel like I'm missing something obvious here. Ed, do you *know* that what

you suggested should work? I can't recall ever using the TOP clause before.

--Brad "Still Strugglin'" Jones

> -----Original Message-----

> From: Ed Leafe

> Sent: Wednesday, July 12, 2000 2:22 PM

>

> Use parentheses.

>

> SELE TOP (parenttable.nQty) ;

> fld1, fld2, fld3 ;

> FROM childtable ;

> ORDER BY 1