could not query the data SELECT SID AS ID, FirstName, LastName, CONVERT(varchar, LectureDate, 101) AS Date, LectureTitle AS Speech, FortnightlyArticle, Series, VideoAudio AS Video, TimeLength AS [Time], VideoLink FROM SPEAKER INNER JOIN PATRONINPUT ON SPEAKER.SpeakerID = PATRONINPUT.PatronID WHERE LastName LIKE '%machan%' AND (Date >= '1/1/1988' AND Date <= '12/31/1988') AND (Series LIKE '%JKL%' AND Series NOT LIKE '%JKLJ%') ORDER BY LastName