SELECT
orders_pedidos.data_pedido AS data_pedido,
orders_pedidos.Total AS Total,
orders_pedidos.Total_impostos AS Total_impostos,
orders_pedidos.Codigo AS Codigo,
orders_pedidos_iten.Reference AS Reference,
Product.Caption AS Caption,
orders_pedidos_iten.quantidade AS quantidade,
orders_pedidos_iten.Total AS Total_or,
orders_pedidos_iten.Total_impostos AS Total_impostos_or,
orders_pedidos_iten.ProdutoCaption AS ProdutoCaption,
orders_pedidos_iten.PrecoUnitario AS PrecoUnitario,
Customer_cliente.Company AS Company,
Customer_cliente.LastName AS LastName,
Customer_cliente.FirstName AS FirstName,
Customer_cliente.Address AS Address,
Customer_cliente.ZipCode AS ZipCode,
Customer_cliente.City AS City,
Customer_cliente.StateDep AS StateDep,
Customer_cliente.Country AS Country,
Customer_cliente.Phone AS Phone,
Customer_cliente.Cell AS Cell,
Customer_cliente.Email AS Email
FROM
Customer_cliente,
orders_pedidos,
orders_pedidos_iten,
Product
WHERE
Product.Reference = orders_pedidos_iten.Reference
AND orders_pedidos.orders_pedidosID = orders_pedidos_iten.orders_pedidosID
AND Customer_cliente.CustomerID = orders_pedidos.CustomerID
AND
(
orders_pedidos.orders_pedidosID = {Paramorders_pedidosID}
)