Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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