Prepared SQLQuery on my DB java

[ReignMan]

hi there guys im trying to do a prepared SQL Query on my Access DB...i need some help getting it work correctly... its a java app I am building so this is what I have:

I have tried:

String query =("SELECT Users.userID,"
		+ " Users.firstName, Users.lastName, UserStocks.symbol,Stocks.name"
		+ " FROM (Users "
		+ " LEFT JOIN UserStocks ON UserStocks.userID = ?)"
		+ " LEFT JOIN Stocks ON UserStocks.symbol = Stocks.symbol;");
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, userID);

And:

String query =("SELECT Users.userID,"
		+ " Users.firstName, Users.lastName, UserStocks.symbol,Stocks.name"
		+ " FROM (Users "
		+ " LEFT JOIN UserStocks ON UserStocks.userID = (?))"
		+ " LEFT JOIN Stocks ON UserStocks.symbol = Stocks.symbol;");
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, userID);

Error for both:

[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.


I used this as a basic query (a place holder) that worked but did not return all the required info for the output i desire:

String query = "SELECT * FROM Users WHERE Users.userID = (?)";
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, userID);

I have code that recives user input and stores it in the userID variable(yes it is being used and runs ok with the section i said works):

InputStreamReader reader = new InputStreamReader(System.in);BufferedReader in = new BufferedReader(reader);
String userID = in.readLine();

Any help would be great thanks in advanced!!

[Rawb]

Access is a little weird with JOINs (at least compared to MySQL?), sometimes requiring nesting of the JOINs using parentheses. If you can, I'd try replacing your parameter with some actual data and try modeling the query in Access.

Another thing you can try is to move the parameter from the JOIN into a WHERE Clause.

String query =("SELECT Users.userID,"
        + " Users.firstName, Users.lastName, UserStocks.symbol,Stocks.name"
        + " FROM (Users "
        + " LEFT JOIN UserStocks ON UserStocks.userID = Users.userID)"
        + " LEFT JOIN Stocks ON UserStocks.symbol = Stocks.symbol"
        + " WHERE Users.userID = ?;");
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, userID);

And

String query =("SELECT Users.userID,"
        + " Users.firstName, Users.lastName, UserStocks.symbol,Stocks.name"
        + " FROM (Users "
        + " LEFT JOIN UserStocks ON UserStocks.userID = Users.userID)"
        + " LEFT JOIN Stocks ON UserStocks.symbol = Stocks.symbol")
        + " WHERE Users.userID = ?)";
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, userID);