|
|
|
|
Re: use of union with case [message #311907 is a reply to message #311900] |
Mon, 07 April 2008 06:18   |
rajatratewal
Messages: 507 Registered: March 2008 Location: INDIA
|
Senior Member |
|
|
Try this out.
SELECT
a.invoice_id, a.accts_pay_code_combination_id account_code, a.invoice_amount inv_amt
FROM
ap_invoices_all a
WHERE a.invoice_id=10384
UNION
SELECT
b.invoice_id, b.dist_code_combination_id account_code,
CASE WHEN a.invoice_amount >0 THEN
-b.amount
ELSE b.amount END inv_amt
FROM
ap_invoice_distributions_all b,ap_invoices_all a
WHERE b.invoice_id=a.invoice_id AND b.invoice_id=10384
|
|
|
|