SQL MINUS/EXCEPT

[Xavier Diab]

Hi

Can't seem to get the minus or except (tried both syntaxes) on caché.
Any idea

Select code, name from ClientForm
EXCEPT
Select code, name from ClientForm Where country='FR'

>> ERROR #5540: SQLCODE: -25 Message: Input (SELECT) encountered after end of query


Thx
Xavier

[Sukesh Hoogan]

Xavier

Try

SELECT code, name FROM ClientForm WHERE country<>'FR'

Regards
Sukesh Hoogan
Bombay, India
- Enterprise Resource Planning
- Business Intelligence
- Financial Accounting
- Offshore Development

[Xavier Diab]

The querry was just for example purpose
Is the Except instruction implemented in caché and in what syntax plz

Thx
Xavier

[Sukesh Hoogan]

Xavier

Does not seem to be. EXCEPT is a reserved word in CacheSQL probably on
account of T-SQL syntax.

I am sure you are aware of the equivalent query in Caché

SELECT code, name FROM ClientForm WHERE country NOT IN (SELECT country
FROM ClientForm WHERE country='FR')