Re: SQL Dilema

Michael Eilman (mike@zeus.towson.edu) wrote: : I am trying to write an SQL Statement to satisy the following situation, : any help is appreciated. There is really not enough information here to give you a credible answer. Please post the schemas of the two tables. Show how you differentiate between teachers and students in Table 1. What do you mean by "Student names - exists for teachers only" in Table 2? This is confusing. - David : 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? : I hope the question is clear. The dilema being that I am trying to : access two different records in Table 1 at the same time. Help!