Hi,
I'm building an application using SAPDB 7.4 and I'm having a big problem with the Subqueries.
The query is a union with subselects in each part of the union. This is a simplified version of the query: select x from .... where x in (...) and x in (....) union select y from .... where y in (...) and y in (....) and y not in ( select x from .... where x in (...) and x in (....) )
The problem is that when some subqueries don't return a result I get an execution failed parse again error.
The solution is to put a value(x, ....) in the select of all the subqueries, but I don't think that should be the solution.
I just noticed the same problem with the union. When one part of the union doesn't return any result I get the same error.
Does anyone know what is wrong here? ( I also tested on a 7.5 sapdb, same error).
So now I have to write my where clause like
value(date , '5000-01-01') <= '1990-01-01') to check if a date is not null. "IS NULL" doesn't work here either.
Thnx,
Sander.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
