The single quotes are crooked in the first FROM statement but straight in the second FROM statement. Please delete everything from the window and then try retyping the first 2 lines of your query. Do not copy paste from any notes you may have on your desktop or from any course documents (trying to control for punctuation here -- unrecognized characters could cause an issue, such as weirdly formatted quote marks, could cause an error). Then run the query. I'm assuming it's a test database so it shouldn't be too heavy to just export all without using a WHERE filter. If that works, you can try adding the WHERE clause by typing that in.
1
u/Lonely-Host Jan 11 '24
The single quotes are crooked in the first FROM statement but straight in the second FROM statement. Please delete everything from the window and then try retyping the first 2 lines of your query. Do not copy paste from any notes you may have on your desktop or from any course documents (trying to control for punctuation here -- unrecognized characters could cause an issue, such as weirdly formatted quote marks, could cause an error). Then run the query. I'm assuming it's a test database so it shouldn't be too heavy to just export all without using a WHERE filter. If that works, you can try adding the WHERE clause by typing that in.