As far as joins go, in T-SQL I mostly use INNER JOIN and LEFT JOIN. I've rarely, if ever, used a RIGHT JOIN. I suppose a RIGHT JOIN is reverse thinking, which i

As far as joins go, in T-SQL I mostly use INNER JOIN and LEFT JOIN. I've rarely, if ever, used a RIGHT JOIN. I suppose a RIGHT JOIN is reverse thinking, which is why I don't use it. A FULL OUTER JOIN I've never had a use-case for I think. Then we have CROSS APPLY, which I've used once or twice. And finally CTEs which I use a lot, in addition to widow functions.