[development-axapta] Help!!!!! How to use Union in Axapta???

[Rando]

Dear All

I want to do this Query on PurchTable_ds.query()

SELECT * FROM PurchTable WHERE ((PurchaseType = Journal))
AND ((PurchStatus = Invoiced))

Union

SELECT * FROM PurchTable WHERE ((PurchaseType = Purchase order)) 
AND ((PurchStatus = Open order))

Could you help me. Urgent!!!


Best Regard

Rando