Retrieve rows that match with all rows from another table

Question

Hi,

 

I have table 1, table 2 and mapping table for these two tables.

Can anybody help me please how to find all persons in table 1 that  attend all schools from table 2 at the same time, without using join keyword, with one select statement?

Thanks! 

Answer 1

I suggest you to post the answer which you solved, and close this thread

Answer 2

at least post the table structure of these 3 tables

 

we cannot guess your table design

Answer 3

I solved it, thanks!