I'm trying to create a select statement with more than 1 table in the from, and more than 1 condition in the where, but the set methods only can receive 1 table in the from (plainSelect.setFrom(Table)) and 1 condition in the where. How can I create a select statement with a list of tables in the from and a list of conditions in the where?.
Thanks for the help!.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi!.
I'm trying to create a select statement with more than 1 table in the from, and more than 1 condition in the where, but the set methods only can receive 1 table in the from (plainSelect.setFrom(Table)) and 1 condition in the where. How can I create a select statement with a list of tables in the from and a list of conditions in the where?.
Thanks for the help!.
getJoins() will give you info about the tables in the FROM clause
The condition is made up of all the binary conditions in the where
Please have a look at the example http://jsqlparser.sourceforge.net/example.php and the code