Re: [HELP] Please, help with a simple SELECT statment

Ezio, you have the outer join backwards. If you want all the rows in the Student table regardless of whether the tut_id column joins with the Tutors table, the query should be:

SELECT *
FROM students, tutors
WHERE students.tut_id = tutors.tut_id (+);

Cheers,
Dave

"Ezio" <vscudel_at_tin.it> wrote in message news:gnDEa.57938$pR3.1237560_at_news1.tin.it...
> Your solution is
> SELECT * FROM STUDENTS,TUTORS
> WHERE STUDENTS.Tut_ID(+)=TUTORS.Tut_ID;
> "Juan Guillermo Fernández V." <promodeus_at_hotmail.com> ha scritto nel
> messaggio news:bbu5pa$k65$1_at_news1.nivel5.cl...
> > Hi everybody.
> >
> > 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
> > can't find a solution to.
> >
> > I've created a table... let's call it "STUDENTS". It has a Primary Key
> field
> > (St_ID) and a bunch of other fields. It also has a Foreign Key (Tut_ID),
> an
> > dientification for his Tutor, a reference to the TUTORS table. The thing
> is,
> > a student MAY or MAY NOT have a tutor, so the Foreign Key field Tutor
MAY
> or
> > MAY NOT have data; id est, it May have an ID number, or else it will be
> > NULL.
> >
> > 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;
> >
> > it shows me only those rows WITH something on the Tut_ID field... and I
> was
> > hoping (and need) to list every row ond STUDENTS, adding the Tutor data
> when
> > it's present, ommiting it (empty fields) when is not...
> >
> > Maybe there is an obvious way to do this, just a simple instruction...
but
> > I'm reourceless on this.
> >
> > 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 - 19:53:44 CDT