DataSet question (two different sources)

Hi,

I have to display data from two databases as a merged (union)
datatable. One source is from MSSQL and the other is from MySQL. Doing
a regularly merging by importing both to a consolidated database is
not an option as it should be accessed live.

I have got it managed to create one dataset accessing each data source
(SQL query) in a Table adapter per query.

I have created a link table ín one of these databases to logically
relate data from A to B.

But now my question: How do I at best create a UNION like select
statement? I assume using SQL itself is not possible, as it will get
sent to the database (which), not the dataset.

Is it the best to use Linq for that and skip binding a dataset to a
grid (GUI)?

Thanks,

Lothar