DB Error: syntax error SELECT C.Composer,R.ID,R.Repertoire_Type,R.Title,R.Role FROM Repertoire_tbl R, Composer_tbl C WHERE R.Artist_ID = AND R.Composer_ID = C.ID ORDER BY Composer,Title,Role [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND R.Composer_ID = C.ID ORDER BY Composer,Title,Role' at line 2]