Hi,
Maybe a bit difficult to explain, but here it is: I need a select statement, with one field that increments.
For example:
SELECT name, country FROM persons WHERE lastname='Jones'
would result in:
[font="Courier New"]
John USA
Pete USA
Mary Canada
[/font]
I need something like:
SELECT cntr, name, country FROM persons WHERE lastname='Jones'
would result in:
[font="Courier New"]
1 John USA
2 Pete USA
3 Mary Canada
[/font]
Anyone?
Thanks!