I have the following query and when I run it I get a message saying it in not supported. The "nodash" is a function that removes dashes from the ssno. I am trying to get records from in my remote view "rv_udfields" that don't match records from my "employee" table. can anyone tell me what I am doing wrong?
SELECT * FROM rv_udfields WHERE employee.e_ssn NOT IN ;
(SELECT nodash(rv_udfields.ssno) from rv_udfields) INTO cursor not_in_vfp
thanks
nick