Hi all, I worked on this for awhile, and i just can't seem to get it right. I have 3 tables, all with the same column names on each table: EMAIL, LASTNAME, FIRSTNAME, SIGNEDIN. the last column, SIGNEDIN contains a value of NULL or 'YES' depending on who signed in. The first 3 column values are the same for all 3 tables.I'm trying to use a join to get collect data on the email address of the people that have a value of NULL for the SIGNEDIN column from all 3 tables. now with this new list of people, i'm going to compare it to another table (TABLE_FOUR) that contains the same EMAIL column list and see if the SIGNED_IN column value of NULL matches the SIGNED_IN FIELD in TABLE_FOUR by email address. Sorry if this sounds confusing, but any help is much appreciated..Thanks, JP