Liveware Publishing Support Forum

As it turnes out it was not the "EXISTS" part of the statement that was causing the error. I zeroed in on that as it was the only thing complex in the statement. ____In fact the problem turned out to be the handling of the following which I omitted from the first post as I did not suspect ...

The question is how to enter the "EXISTS" statement into the R&R query builder.____Mark

Is there a way to use the "EXISTS" in the where clause of a SQL statement?____select * from table 1 __where exists (select * from table 2 where table2.xxx = table1.xxx)____TIA__Mark