EXTERN JOINS Lookup !!!!

From: <jricardo_at_ipb.pt>
Date: Tue, 20 Apr 1999 13:45:37 GMT
Message-ID: <7fi0e0$jq6$1@nnrp1.dejanews.com>

Hi there:

I've 2 tables joined by three fields belonging to the primary key... I want to select all the rows that i have in the tables disciplins even if they dont exist in the table insc

For example

Table disciplins

---

n_disciplina cod_curso ano disciplina

---

    1001           285      1994    computer science
    1002           285      1994    mathemathics
    1003           285      1994    philosophy

Table insc

---

n_disciplina cod_curso ano disciplina value

---

    1001           285      1994    computer science   15
    1003           285      1994    philosophy         10

What i want to retrieve is
Table insc

---

n_disciplina cod_curso ano disciplina value

---

    1001           285      1994    computer science   15
    1002           285      1994    mathemathics       null (*)
    1003           285      1994    philosophy         10

I think this is made with a where clause (+) ... but i've done it and i did that and i didn't get these results...

Disciplins

---

#n_disciplina
#cod_curso
#ano

disciplina
...

Insc

---

#n_disciplina
#cod_curso
#ano

value

If anyone can explain me ... thanks...

--
Thankx
If you know how to help me mail me to jricardo_at_ipb.pt

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 08:45:37 CDT