Join on Interbase

Article View: borland.public.interbase.sql

Article #11027

Back to borland.public.interbase.sql Previous Next

#11027

From: The DeerBear
Date: Thu, 26 Dec 2002 23:08

18 lines
1370 bytes

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

Technical Details

Message-ID: <3e0b8c13@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,fa51700038f7b6f2,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-26 15:25:06 PST
From: "The DeerBear" <rainaple@tin.it>
Newsgroups: borland.public.interbase.sql
Subject: Join on Interbase
Date: Fri, 27 Dec 2002 00:08:01 +0100
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.211.49.173
Message-ID: <3e0b8c13@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040944147 62.211.49.173 (26 Dec 2002 15:09:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail