The easy way to figure this out (find the problem) is to just type out the SELECT as you normally would...
Then, everywhere you see a single quote, add another single quote right next to it. Then wrap the whole thing in single quotes.
--Jeff Moden
Change is inevitable... Change for the better is not.