populate ddl from two tables

[Guest]

Hello,
I have two Tables: Table1: GroupID1, GroupName1 and Table2:GroupID2,
GroupName2.

I have only one dropdown list (DropDownList1) in my application and through
a stored procedure I want to populate my DropDownList1 from GroupName1 and
GroupName2. How should I write my query?
Thanks,
Jim.

 

[Guest]

You'll probably want to use a union.

select companyname from suppliers union select shipcity from orders

try this on Northwind, it'll return the companynames and shipcity in one
long list.

HTH

Pete

 

[Guest]

Can you give me an example?

Jim,

You need to join 2 tables with a UNION query.

Eliyahu

 

[Eliyahu Goldin]

Jim,

You need to join 2 tables with a UNION query.

Eliyahu