You are viewing a single comment's thread from:
RE: SQL Beginner's Tutorial: JOIN Me and Together We Will Rule the Universe
SELECT *
FROM girls
WHERE boobs IS NOT NULL
AND age >=18
ORDER BY age
Just joking.
SELECT *
FROM girls
WHERE boobs IS NOT NULL
AND age >=18
ORDER BY age
Just joking.
You obviously know some SQL because I haven’t covered IS NOT NULL yet. What do you think of the lessons thus far?
Well.
A bit overcomplicated for beginners. i think.
Even the early lessons? Not sure I could make it any less novice than I did... I'm sure it could be done, but not sure I can make it any easier to understand.
Or are you commenting on this Post or the comment you left?
From my experience the best way to explain JOIN is to show SELECT * WHERE field IN (SELECT) and then rewrite the query as join.
What you should never do is to touch VLOOKUP excel function as it works substantially differently.
Few simple examples with tables 2-5 rows large filled with numbers helps a lot also.
Cheers, and please continue.
I hadn't thought of equating to the IN statement. That's a good idea.
Moreover, it's a bit strange that you teach ppl outer joins without them knowing what NULL is.
I did skip that and I'll be trying to tie that in on the next lesson... I know it's a bit of backtracking, but I didn't think of it until it came up in these comments.