Thanks for the reply Mark.

Using your format I tried...

select * FROM jobs
INNER JOIN INVDETL ON INVDETL.JOBNO = JOBS.JOBNO
INNER JOIN PAYMENT ON PAYTMENT.JOBNO = JOBS.JOBNO

Which gives me a "Not a valid SQL statement". If I remove the last join statement it runs and joins JOBS with INVDETL. So what I'm trying to figure out is how to nest all 3 statements.

BTW - the query is entered in a SQL Builder GUI which is part of a commercial software package (DBA Manufacturing) and not sure if the limitation is in the GUI implementation or a Firebird 1.5 limitation.

Thanks again,

Steve

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> 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
>