Select

SUBMITTED BY: Guest

DATE: Feb. 17, 2014, 10:41 p.m.

FORMAT: Text only

SIZE: 447 Bytes

Raw Download

HITS: 1164

Report

	
    SELECT * FROM Order WHERE Id = @OrderId
           
    SELECT * FROM OrderItem WHERE OrderId = @OrderId
           
    SELECT * FROM OrderItem OI INNER JOIN Product P ON OI.ProductId = P.Id WHERE OI.OrderId = @OrderId
           
    SELECT [columns] FROM [table]
    WHERE, JOIN, ETC.
           
    Select * FROM customer c JOIN order o ON c.id = o.customerid JOIN product ON p.id = o.productid