|
|
Posted by Johnny on 10/14/97 11:59
"Tony Louazι" <tlouaze@noos.fr> wrote in message
news:451bbcfc$0$17446$79c14f64@nan-newsreader-07.noos.net...
> Hi, My SQL lessons are very far :(
>
> CREATE TABLE CONTACTS
> (ID INT,
> NAME VARCHAR(10)
> PHONE VARCHAR(10))
>
> CREATE TABLE CLASS
> (CONTACT INT,
> CAT INT)
>
> INSERT INTO CONTACTS VALUES (101, 'toto', '3545')
> INSERT INTO CONTACTS VALUES (102, 'pif', '8421')
> INSERT INTO CONTACTS VALUES (103, 'loulou', '1245')
>
> INSERT INTO CLASS VALUES (101, 1)
> INSERT INTO CLASS VALUES (101, 2)
> INSERT INTO CLASS VALUES (102, 1)
>
> toto owns to category 1 and 2
> pif owns to category 1
> loulou owns to none categories
>
> => how can I display contacts who own to none categories (like loulou) ?
>
> I tried:
> SELECT * FROM contacts LEFT OUTER JOIN class ON id = contact
> I get the list of all contacts...
> but if I add 'WHERE cat = NULL' : there's no result :(
>
> Thanx for your help !
>
>
isn't that what you'd expect? there don't seem to be any null cats in what
you show....
[Back to original message]
|