DB Error: syntax error SELECT C.Composer,R.ID,R.Title,R.Record_Company_ID, R.Disc_Number,RC.Record_Company FROM Discography_tbl R, Composer_tbl C, Record_Company_tbl RC WHERE R.Artist_ID = AND R.Composer_ID = C.ID AND R.Record_Company_ID = RC.ID ORDER BY Composer,Title [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 AND R.Record_Company_ID = RC.ID ORDER BY Composer,Title' at line 3]