SQL server 2005, syntax error - by shasha94 This line do not work: (the problem is in the last line) SELECT Book_Name FROM Books WHERE (Year, Faculty) = (SELECT Year, Faculty FROM Books WHERE Book_Id = 1112); How can I fix it? Read the article