Create a new row

[eislander]

Hopefully one of you can help me with this problem. I need a query to take a table like:

Field1 Field2
------ ------
A B
A C
A D
E F
E G

and output:

Field1 Field2
------ ------
A A
A B
A C
A D
E E
E F
E G


Any suggestions?

Thanks to anyone who posts.

 

[PHV]

Something like this ?
SELECT Field1, Field2 FROM theTable
UNION
SELECT Field1, Field1 FROM theTable
;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[eislander]

That's it! thanks PAV