Android Question Get multiple JdbcResultSet in a single ExecQuery2

[netsistemas]

can i do something sql="select * from table1 ; Select * from table2"
in only one ExecQuery?

(like vb60, vb.net, php and other)




Multi - Recordset/ResultSet

Dim Cursor As JdbcResultSet
Cursor = SQL1.ExecQuery("SELECT col1, col2 FROM table1")
Do While Cursor.NextRow
    Log(Cursor.GetString("col1"))
    Log(Cursor.GetInt("col2"))
Loop

 

[DonManfred]

Inform about INNER JOIN, LEFT JOIN.
See SQL-Tutorials.

In short the answer is NO. You can not use two queries in one call.

But you can use JOIN to get Values from different tables in one call.

Asuming you are using MySQL

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

SQLite

A Visual Explanation of SQLite Joins

In this tutorial, you will learn about various kinds of SQLite joins to query data from two or more tables.

www.sqlitetutorial.net

Once you understand how they are working a new world of possibilities appears

 

[DonManfred]

Multi - Recordset/ResultSet

i havn´t seen a B4X implementation of this.
Even not a JDBC-Version of them.

But as written in my 1st answer you can use JOINs to get Values from another table too if they are related to eachother and you can reference them.

 

[aeric]

INNER JOIN, LEFT JOIN.

and UNION.

Example:

Cursor = SQL1.ExecQuery("SELECT 'table1' AS tbl, col1, col2 FROM table1 UNION SELECT 'table2' AS tbl, col1, col2 FROM table2")
Do While Cursor.NextRow
    Log(Cursor.GetString("tbl"))
    Log(Cursor.GetString("col1"))
    Log(Cursor.GetInt("col2"))
Loop

 

[DonManfred]

and UNION

Yes, UNION is another way

 

[netsistemas]

I already assumed not, but the truth is that it is something that I have discovered that can be done recently (and look, I have been doing this for years) in other languages, even vb60 with recordset!! And just in case, I asked.
Thanks for the response.