sqlschool.gr logo

articles

Articles of SQLschool.gr Team

How joins works in SQL Server

Antonios Chatzipavlis
Friday 07 September 2018





Presentation Code

CHECKPOINT; 
DBCC FREEPROCCACHE; 
DBCC DROPCLEANBUFFERS;
go

select o.orderid, d.qty, c.contactname, p.productname
from sales.Orders as o
inner join sales.Customers as c on o.custid=c.custid
inner join sales.OrderDetails as d on o.orderid = d.orderid
inner join Production.Products as p on p.productid = d.productid
where c.contactname = 'Benito, Almudena'
and p.productname = 'Product VJZZH';
go




CHECKPOINT; 
DBCC FREEPROCCACHE; 
DBCC DROPCLEANBUFFERS;
go

with a as
(
    select o.orderid, c.contactname
    from sales.Orders as o
    inner join sales.Customers as c on o.custid=c.custid

), b as
(
    select d.qty, p.productname ,d.orderid
    from sales.OrderDetails as d 
    inner join Production.Products as p on p.productid = d.productid

)
select a.orderid, b.qty, a.contactname, b.productname
from a
inner join b on a.orderid = b.orderid
where a.contactname = 'Benito, Almudena'
and b.productname = 'Product VJZZH';
go





CHECKPOINT; 
DBCC FREEPROCCACHE; 
DBCC DROPCLEANBUFFERS;
go

with a as
(
    select o.orderid, c.contactname
    from sales.Orders as o
    inner join sales.Customers as c on o.custid=c.custid

), b as
(
    select d.qty, p.productname ,d.orderid
    from sales.OrderDetails as d 
    inner join Production.Products as p on p.productid = d.productid

)
select a.orderid, b.qty, a.contactname, b.productname
from a
inner join b on a.orderid = b.orderid
where a.contactname = 'Benito, Almudena'
and b.productname = 'Product VJZZH'
option (FORCE ORDER)
go





CHECKPOINT; 
DBCC FREEPROCCACHE; 
DBCC DROPCLEANBUFFERS;
go

select o.orderid, d.qty, c.contactname, p.productname
from 
    (
        sales.Orders as o
        inner join sales.Customers as c on o.custid=c.custid 
    )
inner join 
    (
        sales.OrderDetails as d 
        inner join Production.Products as p on p.productid = d.productid
    ) on o.orderid = d.orderid
where c.contactname = 'Benito, Almudena'
and p.productname = 'Product VJZZH'
option (FORCE ORDER);
go

Antonios Chatzipavlis

Antonios Chatzipavlis

Antonios Chatzipavlis is a highly experienced Data Solutions Consultant and Trainer. He has been working in the IT industry since 1988, holding various roles such as senior developer, IT Manager, Data & AI Solutions Architect and Consultant.

Since 1995, Antonios has focused on modern technologies and software development tools, primarily by Microsoft. He has specialized in Data & AI since 2000, with expertise in Microsoft Data Platform (SQL Server, Azure SQL Databases, Azure Synapse Analytics, Microsoft Fabric, Power BI, AI) and Databricks.

Antonios is also a Microsoft Certified Trainer (MCT) for over 25 years, has been recognized as a Microsoft Most Valuable Professional (MVP) in Data Platform since 2010 and he is in the Data Expert 40 Powerlist 2024 by Boussias. He is the co-founder and visionary behind XLYTiCA, a company dedicated to Data & AI solutions.

Episode

Task Flows in Microsoft Fabric

image

More Episodes...

Tip

What's New in SQL Server 2022 - Episodes

More Tips...

Become a member

If you want to receive updates from us become a member to our community.

Connect

Explore

Learn


sqlschool.gr © 2010-2025 All rights reserved

This site uses cookies for operational and analytics purposes only. By continuing to browse this site, you agree to their use.