Query Including 2 Different Tables

Collin writes "i have tried to do a query between 2 different tables that have different columns. within both these tables there is a column that has a column name different from the column name of the other table but the data within both columns is the same. i wanted a query that compares the data between the 2 tables.

Example is:

Table 1
Columns : firstname , age , id , grade.

Table 2
Columns : name, sex , school.

lets say that the data of column "firstname" of table 1 contains the same data as column "name" of table 2 and i would want to do a query that retrieves records for where data in the column "firstname" in table 1 is found in column "name" of table 2.

sql server 2000 with service pack 3 running on windows 2003 server service pack 1
Rgds,
Mr. C. "