>You can't combine multiple tables inside the DataSet. You will need to do that in your select stmt when retrieiving records from the backend.

I think there is a misunderstanding here. The UNION is for the same table where I go get additional field but combine it all within the same field.