اسنیپت‌ها، ترفندها و کدهای کاربردی

-- INNER JOIN
SELECT *
FROM Customers c
INNER JOIN Orders o
    ON c.Id = o.CustomerId;


-- JOIN
SELECT *
FROM Customers c
JOIN Orders o
    ON c.Id = o.CustomerId;


-- LEFT JOIN
SELECT *
FROM Customers c
LEFT JOIN Orders o
    ON c.Id = o.CustomerId;


-- RIGHT JOIN
SELECT *
FROM Customers c
RIGHT JOIN Orders o
    ON c.Id = o.CustomerId;


-- FULL OUTER JOIN
SELECT *
FROM Customers c
FULL OUTER JOIN Orders o
    ON c.Id = o.CustomerId;


-- CROSS JOIN
SELECT *
FROM Customers c
CROSS JOIN Orders o;


-- SELF JOIN
SELECT *
FROM Employees e
LEFT JOIN Employees m
    ON e.ManagerId = m.Id;