Which is the separation character for ... ?

Question

I want to combine these 2 queries :

            string query1 = "SELECT * FROM db1 ";
            string query2 ="SELECT * FROM db2 ";
            string query =query1 + query2;

The tutorial says that this works on SqlServer , but i am using Ms Access
And also the tutorial is saying that there should be a separator(but it doesn't says wich one .... ) between the queries i think something like this :

query =query1 +" ,"+ query2;

but this doesn't works .

Thanks

Le Coder · Answer

Does Access support multiple queries  i dont know... but i think i will solve the problem this way : odbcDA.SelectCommand = new OdbcCommand(query2 odbcConn); // i will send a new //query each time i need one DataTable dt=new DataTable(); odbcDA.Fill(dt); // and put them in a dataTable dtc.Add(dt); // and then in the Data table Collection //maybe this helps also other newcomers :p

Le Coder · Answer

Thanks but the problem is i want to have 2 tables and put them in a DataSet from which in a DataTableCollection and then i could manipulate them separately

John Penn · Answer

You can join them together in SQL: string query1 = select * from db1 union select * from db2 From MSDN the following rules apply for union statements : The number and the order of the columns must be the same in all queries. The data types must be compatible.

Le Coder · Answer

still not working it says something like : characters found at the end of Sql statement :(

Scott Lysle · Answer

query =query1 + ;+ query2;