Multiple tables selection while using Freehand SQL

[manna_das]

Dear All,

How to select multiple tables in Freehand Sql. I am not able to select multiple tables.

Kind Regards

Manna Das

[Former Member · Accepted solution]

Hi,

As suggested above try Join conditions. If you don't know how, go to:

http://www.w3schools.com/sql/

It's a quite good tutorial, you should find what you need there.

Regards,

Bartłomiej.

[manna_das · Accepted solution]

Thanks for the quick reply, but I have three tables to join, what would be the syntax for that?

Kind Regards

Manna Das

[Former Member · Accepted solution]

Should be something like this.

SELECT * FROM table1
JOIN table2 ON foreign_key1_from_table1 = main_key_from_table2
JOIN table3 ON foreign_key2_from_table1 = main_key_from_table3.

[Former Member · Accepted solution]

also check this, googling is not that hard

http://stackoverflow.com/questions/9853586/sql-join-multiple-tables

I hope that I've helped.