Help with SQL query (starts with "WITH")

[#1]

Hi,

I'm pretty new to QV, but got a few simple queries to work and reports created.

I'm now trying to copy and paste a more complex SQL query into QV, but seems to have issues in even recognizing the keywords.

The query is something like this.

WITH xyz AS (Select ...... ) Select .... from xyz

I added the SQL tag in front of 'with' in the QV editor.

Only the 'with' keyword turned blue .... other keywords like Select, from, ... do not seem to get recoganised and as expected, gives an error

SQL Error:[Oracle][ODBC][Ora]ORA-00936: missing expression SQL Scriptline: SQL State:S1000

Any suggestions?

Thanks,

Vijay

[llauses243]

Hi,

WITH only used in Oracle see ... http://www.dba-oracle.com/t_with_clause.htm

See attached ... my offer is to decompose using select and load

good luck, Luis

[#3]

Thanks Luis. I'll try it.