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 -- Mark Rotteveel
