Java.sql.SQlException

Hi,

I am trying to get an SQL statement to check that the users ID and the
ID row in a table match. There maybe up to a hundred users using the
database.

I have two tables in SQl Server express - Users and Property1 both
with a
SurveyID column ie Users.SurveyID and Prop1.SurveyID

The SQL statement is:
String querySQL=("Select * from Prop1_WallFinish where SurveyID =
\"Users.SurveyID\"" );

I am getting a java.sql.SQlException: Invalid column name.

Could anyone point out what is wrong with the statement???

Thanks

Clive

.