Re: Join on Interbase

Article View: borland.public.interbase.sql

Article #11028

Back to borland.public.interbase.sql Previous Next

#11028

From: The DeerBear
Date: Fri, 27 Dec 2002 00:05

27 lines
1795 bytes

Dan Palley wrote:
> 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.

Ok, so how would I make it return _only_ all records which have a
corresponding
USER_ID in the ROLES table?

> The Interbase Data Definition Guide goes into great detail on the
> syntax of the JOIN statement.

Oh, ok, I'll look there.

>Since Interbase syntax is fairly
> vanilla SQL-92, most SQL books are applicable as well (I recommend
> SQL for Smarties by Joe Celko).

I have it :))))

Thanx a lot

> Dan

Andrew

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.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

References: <3e0b8c13@newsgroups.borland.com> <3e0b9474$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,fa51700038f7b6f2
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-26 16:06:27 PST
From: "The DeerBear" <rainaple@tin.it>
Newsgroups: borland.public.interbase.sql
References: <3e0b8c13@newsgroups.borland.com> <3e0b9474$1@newsgroups.borland.com>
Subject: Re: Join on Interbase
Date: Fri, 27 Dec 2002 01:05:28 +0100
Lines: 29
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: <3e0b9941@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040947521 62.211.49.173 (26 Dec 2002 16:05:21 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.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

Reply to Parent Message