Subject | Re: [firebird-support] Queries for 3 or more tables |
---|---|
Author | Ann Harrison |
Post date | 2012-08-31T22:05:47Z |
On Fri, Aug 31, 2012 at 9:33 AM, srotyliano <srotyliano@...> wrote:
multiple tables to create rows with details from each, then joins -inner,
outer, or full - are what you want. If you want to concatenate rows from
multiple tables to produce a result with rows from each, then you want a
union.
Good luck,
Ann
[Non-text portions of this message have been removed]
> What is the best way to script a query for combining data from 3 or moreThat depends on what you want to do. If you want to pull related data from
> tables ?
>
multiple tables to create rows with details from each, then joins -inner,
outer, or full - are what you want. If you want to concatenate rows from
multiple tables to produce a result with rows from each, then you want a
union.
Good luck,
Ann
[Non-text portions of this message have been removed]