Originally posted by M Owen
What do you mean? A query returns a result set ... There is no autonumber capability in a query. As you iterate thru the recordset you may keep a record count that serves the same purpose.
Thanks for your reply.
Since I am using this query in crystal reports, I can't use record set.
My query should look like this.
Select row number,a.coulmn1,b.column2
where a.columnx = b.columnx
Welllll .... Technically CR does use a recordset. They just DON'T LET YOU SEE IT ... That's besides the point ... You might be able to fake it out by querying from a table that has an autonumber column (i.e - grab the data from your primary table(s) and dump it into the "staging area" table that you run youe CR report off of) ...