Subject Re: [firebird-support] Queries for 3 or more tables
Author Mark Rotteveel
On 31-8-2012 15:33, srotyliano wrote:
> What is the best way to script a query for combining data from 3 or more tables ?
> ver: Firebird 1.5

Could you elaborate on what you want to achieve? Normally you would use
INNER JOIN, LEFT JOIN etc to link up tables with conditions that
establish which rows should be joined, eg

SELECT <columns>
FROM table1
INNER JOIN table2 ON table2.column = table1.column
INNER JOIN table3 ON table3.column = table2.column

(the last condition could also be table3.column = table1.column)


Mark Rotteveel