hobbs6

Well, sounds like you need to use a left/right join. Here is a sample query based on the information you gave. It should return a count to you of how many records in table 1 could not match to something in table 2.SELECT count(a.id)  FROM table1 a RIGHT JOIN table2 bON a.id = b.eidWHERE a.id = NULL;

<{POST_SNAPBACK}>

I have two tables, table1 and table2.table1 has a field labelled "id".table2 has a field labelled "eid".I need to see if all of the eid values in table2 are contained in the id values for table1.Essentially I would like the most efficient method for this, possibly using a SELECT statement. Currently, I am getting all the eids in table2 and comparing each row with the entire table1 to see if there is a match between the eid and id.Cheers,Hobbs6