Has anyone tried to do a with statement in TDA and have it execute successfully? If so can you post your format?
(the aggregation SQL statement)
(query naming subquery_name);
(SELECT ID AS CUST_NAME_ID,FIRSTNAME, LASTNAME
(SELECT ID AS CUST_PHONE_ID, PHONE_HOME, PHONE_MOBILE
SELECT FIRSTNAME,LASTNAME, PHONE_HOME, PHONE_MOBILE
FROM CUSTOMER_NAME, CUSTOMER_PHONE
WHERE CUST_NAME_ID = CUST_PHONE_ID
reply.txt (64 Bytes)
still not working
(select * from dual)
select * from charges
I keep getting an invalid SQL error
this is what I am trying to run:
with members as (select * from dual)
select * from members
It executes fine when try it in the soon to be released TDA 3.0 beta.
I was able to successfully execute this statement in TDA 2.7 and TDA 3.0 using Oracle OCI cleint, Direct connect and ODBC. What type of connection are you using and what version of Oracle and client?
Client 10g client
Support for the WITH clause was not added until Oracle 9i.