Subject Re: [firebird-support] Queries for 3 or more tables
Author Ann Harrison
On Fri, Aug 31, 2012 at 9:33 AM, srotyliano <srotyliano@...> wrote:

> What is the best way to script a query for combining data from 3 or more
> tables ?
>


That depends on what you want to do. If you want to pull related data from
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]