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