use qlik table with inner join

[Johnnyg248]

I have the following in my qlikview 12 script.

ClaimCat:
LOAD
C_KEY, N_LGCL_TBL, N_DATAITEM, V_LGCL_COL_ID ,N_CAT,T_EXTFLD_VAL;

SQL select
K.C_KEY, D.N_LGCL_TBL, D.N_DATAITEM, D.V_LGCL_COL_ID ,C.N_CAT,K.T_EXTFLD_VAL

from
[PRD_ADCC00_TST_CFG].[dbo].[LGCL_TBL_DATAITEM_CFG] D
inner join PRD_ADCC00_TST_CFG.dbo.DATAITEM_CFG C on
D.N_DATAITEM= C.N_DATAITEM
inner join PRD_ADCC00_TST_CFG.dbo.CAT_KEY_EXTFLD_LCL_CFG K
on C.N_CAT = K.N_CAT

cross join
(select distinct G_LOSS from PRD_ADCC00_TST_RUN.dbo.LOSS) b

where
C.C_FNCTL_DATA_GRP = 'CLAIM' and C.C_DATAITEM_TYP = 'EXTDATA'
and K.V_ROW_VER in ( select I.V_ROW_VER from PRD_ADCC00_TST_CFG.dbo.CAT_KEY_EXTFLD_LCL_CFG I
where C.N_CAT = I.N_CAT and I.C_KEY=K.C_KEY) ;

DCClaimInfo:

SQL select Distinct
T_CLM_NBR
, C_CLM_STATUS
,case when C_CLM_STATUS in ('OP') then 'OPEN' else case when C_CLM_STATUS = 'CL' then 'Closed' end end ClassStatusDescription
,Lx.T_VAL
,T_EXTFLD_VAL Description
,N_CAT
--,T.Description
,p.T_POL_NBR
,convert(date,D_LOSS_DT) LossDate
,convert(date,D_RPTD) DateReported
,G_CLM

, C_SNSTV
, C_LOB
, C_CLM_FILE_TYP
, D_CLM_ENTRD
, p.G_PARTY
, D_CLOSED
, D_REOPEN
, C_CMPLX
, C_REGLTRY_CNTRL_ST
, C_REGLTRY_CNTY
, C_REGLTRY_CNTRY
, C_HNDLNG_CMPNY
, B_SUIT_FILED
, D_INSRD_NOTIFY
, T_CLM_ACCT_LOC
, T_CLM_ACCT_LOC_DESC
, D_CLMGRP_PUSH
, B_CNVRTD_CLM
, B_CLM_TO_SUIT
, C_HNDLNG_DEPT
, C_DFLT_CURR_UOM
, B_ALLOW_AUTO_PMT
, T_INTRNTL_CLM_NBR
, p.B_RCD_DEL
, p.D_LAST_UPDT
, p.G_LAST_TXN_ID
, c.G_POL
, c.G_LOSS
, B_CLM_ERR
, N_CLNT_STSF
, C_RCVRY_SCR
, C_CLM_SRC
, C_LOB_CTGRY

from PRD_ADCC00_TST_RUN.dbo.CLAIM c

inner join PRD_ADCC00_TST_RUN.dbo.POLICY p on c.G_POL = p.G_POL
inner join PRD_ADCC00_TST_RUN.dbo.LOSS L on c.G_LOSS = L.G_LOSS
inner join PRD_ADCC00_TST_RUN.dbo.LOSS_X Lx on c.G_LOSS = Lx.G_LOSS
inner join ClaimCat on G_LOSS = L.G_LOSS and T.N_CAT = 'ISMIE_ClaimEntryType' and T.C_KEY = Lx.T_VAL

I am getting the following error trying to execute it

ODBC error

Connector reply error: SQL##f - SqlState: S0002, ErrorCode: 208, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'ClaimCat'.

I am trying to use the ClaimCat as a "temp" table.  I think it has something to do with resident keyword but can't seem to get that to work

How do I indicate that the ClaimCat table is not a sql server table but is in fact a table that was loaded in the step above?

[marcus_sommer · Accepted solution]

Qlik doesn't execute the sql else only transfers the statement per driver to the database and received revert the results. This means you couldn't mix up data from within Qlik with the sql-queries (unless you put them variables and used them directly in the sql-statement - it's not really suitable for table-data else just to define small things like a few values for a where-clause or similar).

In your case the ClaimCat table comes from your database, too and therefore you could specify this query directly as inner join within your second query. 

- Marcus