Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa tarde,
Alguém saberia dizer como faço para juntar estas duas tabelas?
Preciso que o campo 'QTY" na tabela OrderDetail só traga valores se o campo 'Trans' da tabela Order se for igual a 'Y'.
Sei que poderia colocar a condição IF em um Gráfico, porém preciso que esta condição já venha do script.
Order:
LOAD
Pedido as Order,
DtPedido as OrderDate,
CGC as Customer,
Represen as Rep,
Trans
FROM
OrderDetail:
LOAD
Pedido as Order,
Modelo as Produc
QTY
// if (Trans = 'Y', QTY) as Order_Qty
FROM
Obrigado,
Rodrigo
Oi, Rodrigo
Pode fazer assim:
Order:
LOAD
Pedido as Order,
DtPedido as OrderDate,
CGC as Customer,
Represen as Rep,
Trans
FROM
OrderDetail:
LOAD
Pedido as Order,
Modelo as Produc
QTY
// if (Trans = 'Y', QTY) as Order_Qty
FROM
inner join (OrderDetail)
Load Order
resident Order
where Trans='Y' ;
Espero que ajude
Abs,
Erich
Oi, Rodrigo
Pode fazer assim:
Order:
LOAD
Pedido as Order,
DtPedido as OrderDate,
CGC as Customer,
Represen as Rep,
Trans
FROM
OrderDetail:
LOAD
Pedido as Order,
Modelo as Produc
QTY
// if (Trans = 'Y', QTY) as Order_Qty
FROM
inner join (OrderDetail)
Load Order
resident Order
where Trans='Y' ;
Espero que ajude
Abs,
Erich
Obrigado Erich!