Dual table

[helen_pip]

Hello

I have written some SQL which is a combination of looking at tables, but contains a sub query based on dual

I have loaded the SQL into qlikview and the ODBC failed to laod and I know this is beacuse it does not recognise the name of my field from the dual sub query

How do I get Qlikview to recognise the field name from dual?

Any ideas?

Thanks

Helen

[#2]

Hi Helen

     Try to use table names into query like TableName.FieldName. Can you post the query?

I hope to help