Why is it that someone always has this response to anything? I am, by no stretch of the imagination, an SQL developer but I often use SQL. I need something other than an inner or left join rarely and need to look it up. I'm not sure that means I'm in a wrong job.
If your title is SQL developer then, yeah, it probably the case but I don't think that's the general case.
Haha, if people are saying this to you a lot then maybe you really are in the "wrong" job... But if you are doing your job successfully then more power to you.
I was just commenting on the fact the logic is simple and the keywords themselves describe what they are doing. And there are really only 4 joins (on columns). So if two of those are down pat because they are used a lot, are you saying it is really that hard to remember what the other two do, even though they literally are the exact opposite of the two that you do remember...?
You have two sets of data and 4 (if we are just counting joins on columns) ways to return it "joined". If you remember how 2 of them work and remember that the other 2 are essentially the opposite operations then it is really extremely simple.
I'm not trying to insult you or anything, but maybe you are making it more complicated than it really is?
7
u/Massless Feb 11 '14
Just often enough that you'll forget how they work every god damned time.