SQL problem: How to select data from two columns in the same table and 1

[JB83]

Dear reader(s),

It looks like a very simple thing to solve, but I haven't seen a lightbulb yet I have a SQL / database problem in MS Access 2000: I don't know how to select data from 2 columns which are in the same table and put them into a combobox which shows data of these two columns.

The situation:

--------- Products ------¬
| OLD NAME   | NEW NAME  |
|------------------------
| productA   | productA  |  
| productB   | productA  |
| productA   | productB  |
| productC   | productD  |
| productD   | productE  |
--------------------------

The combobox will be:

-----------¬
| productA |
| productB |
| productC |
| productD |
| productE |
-----------

There has to be a possibility to select productA, productB, productC, productD and productE by the user.
Should I make a view or can it be done with a SQL command?

Thanks in advance,

Jochen.

 

[mp9]

You could use a union query as the data source of your combo, e.g.

	SELECT [Old name] as NameField
	FROM Products
	UNION SELECT [New name]
	FROM Products
	ORDER BY NameField;

For a no-nonsense overview of union queries, check out

http://www22.brinkster.com/accessory/queries/002.shtml

http://www22.brinkster.com/accessory/

 

[JB83]

mp9,

I have made some additional changes and now it works! Thanks for your reply!

Jochen.