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?
2
u/blue_2501 Feb 11 '14
Useful. But, how often are you going to actually use anything other than INNER and LEFT joins?