I think you're trying to place your WHERE.. in a wrong place, which is your SQL LOAD.
If you don't know the functions and the syntax of your database engine, you can replace all the existing where clause used above with a QLIK WHERE condition that you should put under the LOAD statement
Also, what do yo mean by "The problem here is that it wants the Oracle version of Where Exists()" ?
Will the answer you provided only pull records from the data base that match the loaded fields in memory? The table I am pulling from is huge and I'm trying to avoid pulling everything that matches my SQL LOAD where.
It was asking for the Oracle version of the Exists function. Below is an example of the statement it was looking for. I kept getting an error message like this " ErrorCode: 928, ErrorMsg:[Oracle][ODBC][Ora]ORA-00928: missing SELECT keyword". This makes sense being that I just had a field in the Exists() function but it was looking for a sub-query.
WHERE EXISTS (SELECT *
WHERE customers.customer_id = order_details.customer_id);