SQL in Java

[EdjamacatedGuy]

I'm writing this Java application that queries a database, and my database involves a query that goes


"SELECT uni_list.university, major_list.major
FROM (major_list INNER JOIN uni_major ON major_list.id = uni_major.major_id) INNER JOIN uni_list ON uni_major.uni_id = uni_list.id
WHERE (((major_list.major) Like "*business*"));"

what I came up with is
String major = "Business";

ResultSet rs1=stmt1.executeQuery("select uni_list.university, major_list.major FROM (major_list INNER JOIN uni_major ON major_list.id = uni_major.major_id) INNER JOIN uni_list ON uni_major.uni_id = uni_list.id uni_list where major_list.major like '%"+major+"%'");

I get the error "[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'uni_major.uni_id = uni_list.id uni_list'."

any ideas?

[rmiao]

tried this:

"SELECT uni_list.university, major_list.major
FROM major_list INNER JOIN uni_major ON major_list.id = uni_major.major_id INNER JOIN uni_list ON uni_major.uni_id = uni_list.id
WHERE major_list.major Like "*business*";"