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

SELECT 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 OR 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, 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, ItemPedido ip WHERE ip.idPro =
pro.idPro && ip.idPed <3 ORDER BY ip.idPed;

SELECT idPed, idItePed, idPro, nomePro, qtdItePed, PreUnitPro, (ip.qtdItePed *
pro.PreUnitPro) as "Total" FROM Produto, ItemPedido 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,
SVG(ip.qtdItePed * pro.PreUnitPro) as "Total" FROM Produto pro, ItemPedido ip WHERE
ip.idPro = pro.idPro AND ip.idPed <=3 ORDER BY ip.idPed;