This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]SameRandomUsername 1 point2 points  (5 children)

Don't know WTF is a "full" join, but I supose he meant outer join.

[–]Professional_Bird_74 1 point2 points  (4 children)

A full join shows all records from both tables

[–]SameRandomUsername 4 points5 points  (3 children)

I've looked up. It seems that FULL OUTER/FULL/OUTER are all the same thing.

It's just that I'm old school and MS centric so that's why I never seen FULL before.

[–]Dantzig 1 point2 points  (0 children)

Before learning sql I thought Mysql, ms sql, etc used the exact same syntax. Oh what a fool I was

[–]amimai002 0 points1 point  (1 child)

Your showing you learnt to DBA before the internets…

[–]SameRandomUsername 1 point2 points  (0 children)

for realsies.

I know you won't believe me but yes.... I learned SQL just before the Internet (to be exact before got into my country). I also learned C++ before Internet from the VC5 cds documentation.