I seem to keep getting syntax errors if I try to use WHERE and JOIN ON in the same SQL query. Can you use a where clause in an SQL statement that is written as a JOIN, or do all the "WHERE" conditions for both tables have to be in the ON clause?

Does anybody have a "personal favorite" suggestion for an advanced SQL tutorial / reference?

Thanks very much.