Except???

[Arjan2001]

I made this sql querie:

--------------------------------------------------------
select disinct te.t_code, te.teamnaam
from team te join wedstryd w where te.t_code = w.t_code and not exists
(select distinct veldnr from thuis th
where th.w_code = w.w_code and veldnr = '1')

EXCEPT

select distinct te.t_code, te.teamnaam
from team te join wedstryd w where te.t_code = w.t_code and exists
(select distinct veldnr from thuis th
where th.w_code = w.w_code and veldnr = '1');

---------------------------------------------------------

Powerbuilder does not support EXCEPT, does anyone know how to solve this?
I want the results of veldnr is NEVER 1... in part 1 the results are:
never played on veldnr = '1', but if there are 2 values with one is true and one is false, it will be printed on the screen as well... That's why I want to use the exception...

Thank you for answering,
A. Bruin

 

[carp]

Try using MINUS instead of EXCEPT.

 

[Minus]

If I use Minus I get the following error:

Syntax error: near 'MINUS' in ...and veldnr='1') [[MINUS]] select distinct...