🚀 go-pugleaf

On Fri, 27 Dec 2002 01:05:28 +0100, "The DeerBear" <rainaple@tin.it>
wrote:

>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?

Change LEFT OUTER JOIN to JOIN

What you are asking for is an inner join and that is the default.

>
>> 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
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)