Union Query

[rupes_mahal]

Hi.

I am trying to write a union query and need help.

I have a table containing 6 fields Name1,Name2, Name3, Name4, Name5, Name6. I want to produce a single drop-down list of all these names, and don't know how to write the UNION SQL statement for it.

Can anyone please help

Thank you in advance

Ruby

 

[Rich]

Please continue with the same thread so members can follow. On reflection I'm not sure a Union will work and I'm wondering why you actually need to do this. There would seem to be a design problem here. Please post back with more details of your table design.

 

[rupes_mahal]

Hi rich

thank you for getting back to me. I do actual have a design problem. So please ignore this.

Ruby