Reading Time: 6 minutes When I was first learning how to query databases using T-SQL, I had some very basic questions about the different JOIN operations. I had questions like: “What’s the difference between a JOIN and a LEFT JOIN?” Or “What’s the difference between a regular JOIN and an INNER JOIN?” Or even Continue Reading
UNION and UNION ALL: What’s the difference?
Reading Time: 4 minutes Have you been working with SQL Server for a while, but aren’t really sure what the difference is between UNION and UNION ALL? When I was first learning T-SQL, I wondered this myself. I eventually figured it out, and I was glad to see the difference is very easy to Continue Reading