Bad Design - Combine Tables with Insert

[JurkMonkey]

Hey,

I have 2 tables that have an ID and a string with different names.

Table1: CatID CatName
Table2: BirdID BirdName


I need a way to query both of these items together into one dataset. Then I need to be able to call an insert using that same dataset.

Any ideas how to do this - or how to get around it?

Thanks!

 

[PHV]

You want an union query ?
SELECT CatID ID, CatName PetName FROM Table1
UNION ALL SELECT BirdID, BirdName FROM Table2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JurkMonkey]

That does put all the items into a single list - which is great.

The issue was inserting back into the table via C# DataSets. It tries to dynamically create the query but doesn't support UNION queries. I was hoping to manually build the insert and update commands.

I got around this by simply adding a separate control and splitting the queries up.

Thanks for your help