WHERE NOT EXISTS (SELECT *
I cannot access the Excel data. If I try to double click on the excel data source, it will open a new editor window and if I try to just put in the excel file name, it says that the table or view does not exist. Is this type of query possible?
I am new to TDA and would like to create a query to select data from an oracle table where similar data does not exist in an excel file. I have created the appropriate connections and am able to query from each table. When I open an editor and try to type the following: