select * from customer where exists (select * from orders)result in C5 error. Expected no error (not talking about SQL being logical or not).
CREATE CURSOR customer (Fld1 Int, Fld2 Int , Fld3 Int , Fld4 Int , Fld5 Int , Fld6 Int ) FOR asd = 1 TO 50 APPEND BLANK IN Customer NEXT CREATE CURSOR Orders (Fld1 Int, Fld2 Int , Fld3 Int , Fld4 Int , Fld5 Int , Fld6 Int ) FOR asd = 1 TO 250 APPEND BLANK IN Orders NEXT select * from customer where exists (select * from orders) CLOSE DATA ALL SET PATH TO (HOME(2)+[Northwind]) select * from customers where exists (select * from orders)