OK, this is probably a variation on a previous question but the original question was never resolved, so I will present it on it's own to avoid confusion.
I have a member data table called 'members'
Primary key is 'mem_id'
I have 7 different 'position' tables called
position_1, position_2, position_3, etc...
What I need is a single query to get all records from the members table
SELECT mem_id, user, fname, lname, email
AND the mem_id does NOT exist in any of the 7 position tables in the field also called 'mem_id'
Simple, RIGHT? LOL
I'm hoping that it is relatively simple, or at least understandable for someone that really doesn't understand joins except for the simplest applications.
Thanks in advance.
Edited by showman13: n/a