Re: Please help w/ SQL question

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/05/25
Message-ID: <eg3riss9jhe0crtnn8rotvfllapjr48kti@4ax.com>#1/1

Is this the behavior that you are after:

SQL> select * from user_lu;

USER_LU

---

name
address
city

SQL> select * from user_lu_value;

USER_LU USERNAME VALUE

------- -------------- -------------------------

name foobarusername Sean

SQL> set null ***null***
SQL> l
  1 select user_lu.user_lu_id, v.value
  2 from user_lu, user_lu_value v
  3* where user_lu.user_lu_id = v.user_lu_id (+) SQL> / USER_LU VALUE

------- ------------------------------

address ***null***
city ***null***
name Sean

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Thu, 25 May 2000 16:44:37 GMT, Sean <dolans_at_my-deja.com> wrote:

>I have two tables: a lookup and a value table. Let me describe them
>below:
>
>USER_LU
>===============
>USER_LU_ID (PK)
>--------------
>DISPLAY
>
>
>USER_LU_VALUE
>===============
>USER_LU_ID (PK)
>USERNAME (PK)
>---------------
>VALUE
>
>
>Some values that would be in the lookup table: {1, NAME} {2,ADDRESS}
>{3, CITY}
>Some values in the Value table : {1, 'foobarUsername', 'Sean'}
>
>What I am trying to do is get a list of ALL the lookups with a value
>for a certain username, but throw a NULL if not there as in:
>{given a username of foobarUsername}
>NAME Sean
>ADDRESS NULL
>CITY NULL
>
>ALL I Keep getting is
>NAME Sean
>
>
>I have tried outer joins but the problem comes in when I specify
>USERNAME = '{something}' It all goofs up.
>
>Any ideas of accomplishing this?
>Thanks,
>Sean
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu May 25 2000 - 00:00:00 CDT