Q67776 – Tecnologia da Informação – Fundação Carlos Chagas 2018

SELECT JOIN ip.idPed, ip.idItePed, ip.idPro, pro.nomePro, ip.qtdItePed, pro.PreUnitPro,
(ip.qtdItePed * pro.PreUnitPro) as Total FROM Produto pro, ItemPedido ip WHERE ip.idPro =
pro.idPro AND ip.idPed <=3 ORDER BY ip.idPed;

JOIN ip.idPed, ip.idItePed, ip.idPro, pro.nomePro, ip.qtdItePed, pro.PreUnitPro,
(ip.qtdItePed * pro.PreUnitPro) as Total ON Produto pro, ItemPedido ip WHERE ip.idPro =
pro.idPro AND ip.idPed <=3 ORDER BY ip.idPed;

SELECT idPed, idItePed, dPro, nomePro, qtdItePed, reUnitPro, (qtdItePed * PreUnitPro) as
Total FROM Produto pro JOIN ItemPedido ip WHERE ItemProduto.idPro = Produto.idPro AND
ItemProduto.idPed <=3 ORDER BY idPed;

JOIN ip.idPed, ip.idItePed, ip.idPro, pro.nomePro, ip.qtdItePed, pro.PreUnitPro,
(ip.qtdItePed * pro.PreUnitPro) as Total FROM Produto pro, ItemPedido ip WHERE ip.idPro =
pro.idPro AND ip.idPed <=3 ORDER BY ip.idPed;

SELECT ip.idPed, ip.idItePed, ip.idPro, pro.nomePro, ip.qtdItePed, pro.PreUnitPro,
(ip.qtdItePed * pro.PreUnitPro) as Total FROM Produto pro JOIN ItemPedido ip ON ip.idPro =
pro.idPro AND ip.idPed <=3 ORDER BY ip.idPed;