SQL QUERY Converter

[#1]

HI All,

I have the query as below and I need to convert it into QV. Can anybody have a look into this

Select DBO.CASE_END2END.ACCOUNTABILITY_ID,
    DBO.CASE.CASE_ID,
    DBO.CASE.CL_Date_GMT,
    DBO.SUBCASE.SubCase_ID
from DBO.CASE
left join DBO.SUBCASE on DBO.CASE.ACCOUNTABILITY_ID = DBO.SUBCASE.ACCOUNTABILITY_ID
WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

Thanks,

Chiru

[alexandros17]

Select DBO.CASE_END2END.ACCOUNTABILITY_ID,
    DBO.CASE.CASE_ID,
    DBO.CASE.CL_Date_GMT
from DBO.CASE
WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

left join

Select DBO.SUBCASE.ACCOUNTABILITY_ID
    DBO.SUBCASE.SubCase_ID
from  DBO.SUBCASE;

But you can run the first in qlik as it is.

[IAMDV]

Something like this...? Where you extract the data from both tables and join predicate will be ACCOUNTABILITY_ID. I assume that ACCOUNTABILITY_ID is available in both the tables.

Case_Table:

LOAD *;

Select

  DBO.CASE.ACCOUNTABILITY_ID

    DBO.CASE_END2END.ACCOUNTABILITY_ID,
    DBO.CASE.CASE_ID,
    DBO.CASE.CL_Date_GMT,
    DBO.SUBCASE.SubCase_ID
from DBO.CASE

WHERE DBO.CASE.ACCOUNTABILITY_ID = '464921';

left join (Case_Table)

LOAD *;

Select

  DBO.SUBCASE.ACCOUNTABILITY_ID

    DBO.SUBCASE.SubCase_ID

from DBO.SUBCASE

I hope this helps!

Cheers,

DV

www.QlikShare.com