Untitled

 avatar
unknown
plain_text
2 years ago
406 B
3
Indexable
CREATE DEFINER=`root`@`localhost` PROCEDURE `DisplayBillProducts`(
  IN billId INT
)
BEGIN
  SELECT
    cod.SKU,
    t.Name,
    cod.Quantity,
    cod.Price
  FROM
    CustomerOrderDetail cod
    INNER JOIN CustomerOrder co ON cod.CustomerOrderId = co.CustomerOrderId
    INNER JOIN Bill b ON co.CustomerOrderId = b.CustomerOrderId
    INNER JOIN Toy t ON cod.SKU = t.SKU
  WHERE
    b.BillId = billId;
END
Editor is loading...