Most efficient query

I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from MainTable that just

Re: Most efficient query

Subject: Most efficient query I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each. The other, which we'll call MapTable, is simply a key mapping table with ids from

Re: Most efficient query

Correction. I can see a mistake in my syntax. the correct statement to pull the list of name in MainTable that ARE in mapMainTable is: select MainTable.Name from MainTable inner join MapTable using (ID); this works. but how can I pull the list of names that ARE NOT in the map table? Augey

RE: Most efficient query

PROTECTED]] Sent: Thursday, May 09, 2002 5:11 PM To: [EMAIL PROTECTED] Subject: Most efficient query I have two tables. One table, which (to protect the innocent :-)) we'll call MainTable, has a list of names with user info like address, etc.. and an auto-incrementing unique id for each