Sql select question

Hello everybody,

i have the following table (agltransact), in which 2 fields are relevant:

ex_inv_ref account

15          1512
15          6040
16          1512
16          1512
16          6040
16          6040
17          1512
17          1512
17          1512
17          6040
17          6040
18          1512
18          1512
18          6040
18          6040
18          6040
18          6040

select ext_inv_ref,
from agltransact
where client='MG' and account in('1512','6040') and ext_inv_type >= 15 and ext_inv_type <= 17
group by ext_inv_ref
having round(count(account)/2,0) != count(account)/2;

this select only those ext_inv_ref with an uneven number of accounts, so ext_inv_ref

how would you write a query like that ?

thanks,
Andy Received on Wed Nov 19 2003 - 22:53:16 CET