join question

[Claudius Sailer]

Hi Charles,


Am Samstag, 28.06.03, um 21:34 Uhr (Europe/Berlin) schrieb Charles 
Yeomans:

>> SELECT teacher.*
>> FROM teacher t, jointable j1, jointable j2
>> WHERE t.RecID=j1.teacherptr
>> AND t.RecID=j2.teacherptr
>> AND j1.studentptr=1
>> AND j2.studentptr=2
>>
>> is this a runnable way?
>>
>
> This will return 0 results.  I'm thinking that it's some sort of inner 
> or outer join, but I've no experience with them.

*hmmmm* I don't have my documents here and also less inner-outer-join 
experiences, so you have to wait until user with better SQL know how 
will help you.

bye


Claudius