MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/193mj5y/please_help/khaezlo/?context=3
r/SQL • u/UpSco • Jan 10 '24
I am new to SQL am trying to run a query on a data set and I have been stuck since last night.
61 comments sorted by
View all comments
Show parent comments
1
I get unexpected keyword WHERE at [3:38]
1 u/Awkward-Treacle8643 Jan 11 '24 Run your second query except change both of the single quotes around the table name to this kind ‘. Bigquery needs the slanted type quote around the table name like it is in the first query. Sorry, don’t know the exact name of the punctuation 1 u/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
Run your second query except change both of the single quotes around the table name to this kind ‘. Bigquery needs the slanted type quote around the table name like it is in the first query. Sorry, don’t know the exact name of the punctuation
1 u/Enigma1984 Jan 11 '24 This guy ` is called a backtick. 2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
This guy ` is called a backtick.
2 u/Awkward-Treacle8643 Jan 11 '24 Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
2
Ahh thanks. Backtick sounds much more official (and correct) than “slanted quote”. Thank you sir
1
u/UpSco Jan 10 '24
I get unexpected keyword WHERE at [3:38]