Which is the separation character for ... ?

Le Coder

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Le Coder18y ago
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 Coder18y ago
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
Guest User18y ago
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 Coder18y ago
still not working ,it says something like : characters found at the end of Sql statement :(
Scott Lysle18y ago
query =query1 +" ;"+ query2;