Skip to content
Advertisement

SQL Left Join after UNION, error in your SQL syntax [closed]

This is my SQL, but I get “error in your SQL syntax”:

Advertisement

Answer

You’re missing FROM keywords in the UNION subquery. (SELECT * FROM Product01 UNION SELECT * FROM Product02)

Also, you seem to be trying to declare the subquery as pr and then use it later, but that’s not how SQL’s syntax works.

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement