What would be the correct SQL syntax for the following:

example : I have two tabeles
1. Baset_Ball_Players
2. Students

in the table Baset_Ball_Players there is a field called Player_Name and in Students there is a field called Student_Name.

How could I do a search to find all the matches where Player_Name = Student_Name.

Just like finding the Names that are similar in the two tables.

Another question, is this possible with two seperate database files??


------------------
OmarSwan

[email protected]

http://omarswan.da.ru/

"Jesus is Lord"