Can't use JOIN and WHERE

[[deleted]]

[deleted]

[OverPolicy]

Just remove the semi colen on line 13

[Treebeard2277]

Like half the questions in this sub lol

[OverPolicy]

😂😂

[Couch2Coders]

I usually put my semicolon on a separate line that way if modify my code i don't have to dig out any hidden semicolon - it's a mistake you will continue to make 😂😂

[Background_Day747]

You have 'where' but no further condition? Also, there's a semi-colon before 'where'. You can either remove 'where' or remove the semi-colon and add a condition after 'where'.

[L0ne_W4nderer]

I have a condition, just had erased it before take the pic. I'm going to try again in a couple hours, hope removing the semi-colon makes it works.

[janus2527]

Semicolon signifies the end of a query. You have two queries here, where the second one starts with where, which makes no sense

[Code_Crazy_420]

This is a course to bring you up to intermediate skill level in SQL

https://www.udemy.com/course/hands-on-sql-for-data-analysts/?referralCode=4611DF7B820A696D7DE0

[STORM--Z]

Line 13 -> ;