Re: Okay, maybe a silly basic SQL question, but

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Fri, 29 Dec 2000 14:18:17 -0500
Message-Id: <10725.125465@fatcity.com>

select mu.user_name,ma.account_name
from my_users mu,

          my_accounts ma,
          my_association_table mat

where mu.user_name =3D mat.user_name
and ma.account_no =3D mat.account_no;

>>> Susan E Teague <Susan_at_fileFRENZY.com> 12/29/00 01:40PM >>>
Hello all,
I'm just starting to code in PL/SQL and am still learning SQL too! So, hopefully this question is not too basic or painfully obvious!
I have 3 tables - one contains a user_name, the next has the user_name and the account_no (an association table between users and accounts) ,=20 the third has the account_no and the account_name. I need the user_name = and
its associated account_name.

I did a join on the 3 tables to get my desired results (hopefully I did = this
correctly), but I'm wondering if there is a more succinct and better way of getting the desired results. Aren't 3 way joins costly? And if so, what are other options?

Example of what I've come up with:

select u.user_name, u.status,
decode(u.status, 1, 'Temporarily Suspended', 2, 'Permanently Suspended', = 3,
'Password Reset', 4,=20

        'First Login', ' ') as statusdesc, a.account_name=20 from user u, user_acct_asc ua, account a where
u.status <> 0
and u.status_date between sysdate-1 and sysdate and u.user_name =3D ua.user_name
and ua.domain_id =3D a.domain_id;

cheers,
susan

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Susan E Teague
  INET: Susan_at_fileFRENZY.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Dec 29 2000 - 13:18:17 CST