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