I read a lot about this, but I have not come across any solutions. I have a dataset with 3 tables. How to populate these 3 tables in a dataset? Is it possible to use only one sql query with many joins?
select * from tableA where <condition> select * from tableB where <condition> select * from tableC where <condition>
will return three tables (DataSet)