In a real world scenario, we can sale in our online store on standard or discounted prices. In this exercise we use three tables to demonstrate the zig-zag JOIN:
Monthly Archives: July 2016
3 posts
I am very happy to announce that my first book, dedicated to Microsoft SQL Server from the Learn Intuitively series is now on KickStarter.
When we write a DML query that is using JOINed tables as data source, first we need to understand the way SQL Server is manipulating the data. The clauses in the DML query statement are ordered as follows: SELECT FROM… JOIN WHERE GROUP BY HAVING ORDER BY Behind the scene […]