Re: SQL Dilema
>> Table 1 - People - Teachers and Students
>> Table 2 - Student names - exists for teachers only, linked to Table 1 by
>> field X
>> How do I produce output on a Teacher, his/her students, and Specific
>> detail on the students contained in Table 1?
select t.name, d.*
from table1 t, table2 s, table1 d
where t.x in (select unique x from table2)
and t.x = s.x
and s.name = d.name
order by 1