Hi All,
Can anyone please tell me how to covert below SQL sub query into Qlilk?
select [TYPE], coverage, COVERCODE, EXC, EXCGINAL, SELECTED, deprecated
from [S_CVG_VER]
where end_dt = '9999-12-31' and EFCTV_END_DT = '9999-12-31'
and [TYPE] in
(select PACKAGECODE from s_pkg_ver pk1 ,
(select distinct packageselected, h_plcy_id
from s_pkg_ver
where end_dt = '9999-12-31'
and EFCTV_END_DT= '9999-12-31' and h_plcy_id = 47858 ) pk2
where pk1.h_plcy_id = 47858
and end_dt = '9999-12-31'
and EFCTV_END_DT= '9999-12-31'
and pk1.h_plcy_id = pk2.h_plcy_id
and packagedesc = pk2.packageselected)
When I am execute this into qlik getting below error
Anyone can help on this?
