HOWTO express an SQL UNION

2007-05-07 Thread Valeriu Nedelcu
Hi all, I'm confronted with the following problem: Find all INVOICEs that were issued by OR from a PARTY and then display some info about them. In other words, I want to obtain a SQL similar with the following UNION: SELECT sender_id, receiver_id, COUNT(invoice_id) FROM ( (SELECT

Re: HOWTO express an SQL UNION

2007-05-07 Thread Chris Howe
Hi Val, The Screen Widget, Form Widget and Simple methods support entity-condition For your particular scenario you would want to do something like the following entity-condition entity=Invoice list=listIt condition-list combine=or condition-expr field-name=partyId