5 Comments

    Select c.CustomerName, o.OrderId, c.ContactName from Customers c
    left join Orders o on c.CustomerID= o.CustomerId;

    select customers.customername,orders.orderid from customers left outer join orders on customers.CUSTOMERID=orders.CUSTOMERID;

    select customers.customername, orders.orderid from customers
    LEFT JOIN Orders
    on customers.customerid=orders.customerid order by customers.customername;

    SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID=Orders.CustomerID

    SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID=Orders.CustomerID

Leave a Reply

Loading Questions

If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com