It looks to me like you have two problems.

First, your select statement is trying to select from a table named
"Prop1_WallFinish" rather than from either of the tables you mention,
Users and Property1.  Perhaps you actually mean

    select * from Property1 ....

Second, your "where" clause looks fishy.  Assuming that you really mean
to select rows from the table named Property1, then your query appears to be

  select * from Property1 where SurveyID = "Users.SurveyID"

which is testing an ID column, which is presumably a number, against a
literal string "Users.SurveyID".

Are you trying to match rows in the Property1 table which have the same
SurveyID column as rows in the Users table?  That's called a join.  It's
a very common type of query, but the syntax is different than what
you're trying to use.

May I suggest that you read the documentation for your database system
and pay close attention to the chapter which explains joins.  It will
tell you how to query across two tables.  Use your database system's
command-line query tool to talk directly to your database server and try
out various different queries before you take the leap to programming
them in Java.  One hurdle at a time ... :-)

David Harper
Cambridge, England