>Terry,
>
>This is off-the-wall and I haven't tested it, but what about this:

>
>SELECT RECNO('invoice') AS invrec, a.fname, a.lname, b.invoice FROM Customer a, Invoice b WHERE a.num = b.num INTO CURSOR lcTest

>
>Note the change to how RECNO() is being used.
>
>

John/Mike:

I'm surprised at you guys! < BG > You know you can't use an alias name in a SQL SELECT statement for RECNO(). It's clearly stated in the docs.

John, your solution to do it in two parts will work.