Getting Data from 2+ Tables Into 1 Query

[Jakz34]

I have 4 tables that I am working with.



Table 1 is a list of all people in a section who need to register for tickets
Table 2 is a list of people who have registered for tickets.


Is there anyway to cross these two tables so that anybody who is listed in table 1 but not 2 is pulled out via query?

[ajetrumpet]

try:

select person from table1 where person 

not in (select person from table2)

[weekend00]

Please note that if the tables have big amount of records, NOT IN condition works very slowly. in this case, JOIN query is recommended.

[Jakz34]

try:

select person from table1 where person 

not in (select person from table2)

Where would I put this code?

[Jakz34]

Please note that if the tables have big amount of records, NOT IN condition works very slowly. in this case, JOIN query is recommended.

Yeah, I looked at join query but I wasn't sure which of the three options to choose.

[ajetrumpet]

Where would I put this code?

in the query sql view.