You are viewing a single comment's thread from:
RE: SQL Beginner's Tutorial: JOIN Me and Together We Will Rule the Universe
That’s a good response. I like hearing true statements.
Did you read the previous lessons first? Because I would love for you to go back and read the other posts and then return and re-read this one to see if that helps.
If you can do that and give me an assessment from your perspective it would shape the future of my lessons.
Thanks for the honesty.
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.