Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue with Joins

Hi Team ,

I have written a query which is perfectly executing ,when im using in the script its throwing error ,  I assumed initially it was DB error but rest of the Queries are executing and loading from same DB .

kindy suggest if any errors or catch points where qlikview is not allowing it.

Please find the attached Screen print .

select * from

(select  intf.ext_interface_nm PHWEB_INTERFACE_NM,

         SLA_THRESHOLD PHWEB_THRESHOLD,

         CUTOFF_SLA_THRESHOLD PHWEB_CUTOFF,

         to_char(ft.reception_dt,'mm/dd/yyyy') RECEPTION_DATE,

         to_char(ft.reception_dt,'hh24:mi:ss') PHWEB_INTIME

from zyadm.zy_interface_t intf, zyadm.zy_file_t ft

where intf.interface_id = ft.interface_id

and   ft.reception_dt> = sysdate-7

and   ft.interface_id = 1000) PHWEB

LEFT OUTER JOIN

(select  intf.ext_interface_nm GPSY_INTERFACE_NM,

         SLA_THRESHOLD GPSY_THRESHOLD,

         CUTOFF_SLA_THRESHOLD GPSY_CUTOFF,

         to_char(ft.reception_dt,'mm/dd/yyyy') RECEPTION_DATE,

         to_char(ft.reception_dt,'hh24:mi:ss') GPSY_INTIME

from zyadm.zy_interface_t intf, zyadm.zy_file_t ft

where intf.interface_id = ft.interface_id

and   ft.reception_dt> = sysdate-7

and   ft.interface_id = 1003) GPSY

ON GPSY.RECEPTION_DATE = PHWEB.RECEPTION_DATE;

2 Replies
Clever_Anjos
Employee
Employee

That´s because you have RECEPTION_DATE in both query´s

Select * will bring RECEPTION_DATE twice that Qlik does not permit.

Never user select *, list only the fields you want

Not applicable
Author

thanks Anjos its really helpful