AnsweredAssumed Answered

EXCEPT in ExecuteSQL  (fmp12) supported?

Question asked by Oliver_Reid on Aug 6, 2012
Latest reply on Aug 8, 2012 by Oliver_Reid

I want to do

 

Select ......

 

EXCEPT

 

Select ...

 

 

 

 

Where each Select returns a single column, (both with the same name) to find the values returned by the first query that are not returned by the second

 

But I get a "?"

 

 

If I use UNION instead I get the union of the two results -- is EXCEPT not supported?

 

 

The situation is like as library where I want to find the ids of all copies of a certain book title that are not checked out.

 

If it's checked out there is a record in a book-borrowing table with the book id, and returned date is empty.

 

So I want to find the ids all copies of a specified title EXCEPT those that are refrenced in borrowing record where the returned date is empty.

 

(Note most copies have many borrowing records with a non-empty returned date)

 

I have done this with various list calcs and TO's but I want to do it with ExcuteSQL and simplify my TOG

Outcomes