You are viewing a single comment's thread from:
RE: SQL Beginner's Tutorial: JOIN Me and Together We Will Rule the Universe
That was my mistake, i do have some database concepts so i did not start with the previous ones. i can handle things with the interface which is why the queries look complex without the GUI. after i posted the comment i went back and re-read another time i do get it. will take some practice to do some scenarios but with your examples they do make sense. great effort. I never did use the On clause directly before.
In MS SQL (if writing out your own SQL queries) you need an ON clause any time you use the JOIN statement.