topic Re: Dual table in QlikView https://community.qlik.com/t5/QlikView/Dual-table/m-p/473441#M1149079 <HTML><HEAD></HEAD><BODY><P>Hi Helen</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try to use table names into query like TableName.FieldName. Can you post the query?</P><P></P><P>I hope to help</P></BODY></HTML> Mon, 17 Jun 2013 12:51:35 GMT 2013-06-17T12:51:35Z Dual table https://community.qlik.com/t5/QlikView/Dual-table/m-p/473440#M1149078 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have written some SQL which is a combination of looking at tables, but contains a sub query based on dual</P><P></P><P>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</P><P></P><P>How do I get Qlikview to recognise the field name from dual?</P><P></P><P>Any ideas?</P><P></P><P>Thanks</P><P>Helen</P></BODY></HTML> Fri, 14 Jun 2013 14:22:42 GMT https://community.qlik.com/t5/QlikView/Dual-table/m-p/473440#M1149078 helen_pip 2013-06-14T14:22:42Z Re: Dual table https://community.qlik.com/t5/QlikView/Dual-table/m-p/473441#M1149079 <HTML><HEAD></HEAD><BODY><P>Hi Helen</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try to use table names into query like TableName.FieldName. Can you post the query?</P><P></P><P>I hope to help</P></BODY></HTML> Mon, 17 Jun 2013 12:51:35 GMT https://community.qlik.com/t5/QlikView/Dual-table/m-p/473441#M1149079 2013-06-17T12:51:35Z