there are no unions in axapta why not
SELECT * FROM PurchTable WHERE ((PurchaseType = Journal) AND (PurchStatus = Invoiced)) OR ( (PurchaseType = Purchase order) AND (PurchStatus = Open order)) -----Original Message----- From: "Rando" <[EMAIL PROTECTED]> To: [email protected] Date: Thu, 26 Apr 2007 04:53:57 -0000 Subject: [development-axapta] Help!!!!! How to use Union in Axapta??? > > 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 > > > > > > > > > Yahoo! Groups Links > > > > -- http://belugin.info ICQ:9406811 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/development-axapta/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
