hey guys if i am working with two different tables, table 1 has a list of names and table 2 also has a list of names . What i would like to know is what query can i use to count the number of names from table 1 that are the same with table 2. i came up with this query select count(*) from table 1 where name=name but as you can see i have only selected 1 table .how do i check table 1 against table 2.