I am having some trouble with a select statment in Qlikview. The query runs fine if I run it outside of Qlikview in SQL developer. This is a Oracle database Qlikview is running on a 64bit wnidows 2003 server. Whats odd is that i have muliple queries that use this same join but QlikView throws an error on 2 of my quries
DROP TABLE ORDER; [\code] This runs fine <pre> SELECT DISTINCT c.CLNT_CDE, c.COMPANY_CDE, c.DLY_ORD_SBGRP_CDE, c.DLY_ORDER_CDE, c.DLY_ORDER_NAME, c.LAST_UPDATED, c.MARKETING_CDE, c.ORDER_WIP_FLG, c.PERFORMANCE_CDE, c.SCHED_TYPE_CDE, c.VERSION, c.WATCH_LIST_FLG FROM VS_CLNT_RPTS c JOIN AP_MS_ATM_QLIKVIEW_ORDERS q on q.CLNT_CDE=c.CLNT_CDE AND c.COMPANY_CDE= q.company_cde ; STORE VS_CLNT_RPTS INTO \\Servicelink.com\slfiles\Development\QlikView\Vision\ATM_VS_CLNT_RPTS.qvd(qvd);