Thanks Alex,

Changing the typo and changing the second inner join to just join did the trick. I'm back in business !

Thanks for the speedy response and have a great weekend !

Stvee

--- In firebird-support@yahoogroups.com, "Alex" <alex@...> wrote:
>
> Hi,
> correct your second statement where it reads PAYTMENT.JOBNO in
> PAYMENT.JOBNO:
>
> select * FROM jobs
> INNER JOIN INVDETL ON INVDETL.JOBNO = JOBS.JOBNO
> INNER JOIN PAYMENT ON PAYMENT.JOBNO = JOBS.JOBNO
>
> and add a third JOIN clause to get the third table data too. Experiment
> with LEFT JOIN instead of INNER JOIN.
>
> Best regards
> Alex
>
> ----- Original Message -----
> From: "srotyliano" <srotyliano@...>
> To: firebird-support@yahoogroups.com
> Date: Sat, 01 Sep 2012 14:16:34 -0000
> Subject: [firebird-support] Re: Queries for 3 or more tables
>
> > 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
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>