🚀 go-pugleaf

Basically, you're combining values from two tables (ACCOUNTS and ROLES) into
a single result set.  The relationship between the two tables is based on
user_id.  Since you're doing a left join, records in ACCOUNTS with no
corresponding ROLES records will still be included in the result set.

The Interbase Data Definition Guide goes into great detail on the syntax of
the JOIN statement.  Since Interbase syntax is fairly vanilla SQL-92, most
SQL books are applicable as well (I recommend SQL for Smarties by Joe
Celko).

Dan

"The DeerBear" <rainaple@tin.it> wrote in message
news:3e0b8c13@newsgroups.borland.com...
> Hello,
>
> Lurking in this group, I came up with this query:
>
> Select ACCOUNTS.LAST_NAME,ACCOUNTS.first_name, ROLES.user_role FROM
ACCOUNTS
> ACC Left Outer Join ROLES R ON R.user_id = Acc.user_id .
>
> I made it work as expected, but there's a small prob... I have NO clue
about
> why it
> worked... <G>
>
> I explain: I managed to make it work, but I'm totally clueless on how
joins
> work...
> would any pietous soul explain me what that SQL statement means?
>
> TIA
>
> Andrew
>
>