[HELP] Please, help with a simple SELECT statment

[Quoted] I've been working for a just a while now with Oracle (or with any DB for that matter. I'm really new to all this), and I've encountered a problem I [Quoted] can't find a solution to.

I've created a table... let's call it "STUDENTS". It has a Primary Key field [Quoted] (St_ID) and a bunch of other fields. It also has a Foreign Key (Tut_ID), an [Quoted] [Quoted] dientification for his Tutor, a reference to the TUTORS table. The thing is, [Quoted] [Quoted] a student MAY or MAY NOT have a tutor, so the Foreign Key field Tutor MAY or [Quoted] MAY NOT have data; id est, it May have an ID number, or else it will be NULL. [Quoted] [Quoted] Now, here's where I'm having the problem. When I do a simple:

SELECT * FROM STUDENTS,TUTORS

                  WHERE STUDENTS.Tut_ID=TUTORS.Tut_ID;

[Quoted] [Quoted] it shows me only those rows WITH something on the Tut_ID field... and I was [Quoted] [Quoted] hoping (and need) to list every row ond STUDENTS, adding the Tutor data when [Quoted] [Quoted] [Quoted] it's present, ommiting it (empty fields) when is not...

[Quoted] Maybe there is an obvious way to do this, just a simple instruction... but I'm reourceless on this.

[Quoted] Pleasy. Any help would be enourmosly appreciated. thanks!

PS: Sorry for my english, if it tourns out inintelligible or horrible misspelled. Received on Sun Jun 08 2003 - 04:07:38 CEST