nested query

[PappaG]

Hi can anyone spot the errrr ...deliberate error

SELECT VQNIVR, T.DATE_YYYYMMDD, V.AV_T_ANSWERED, V.AV_T_ABANDONED, V.AV_T_DISTRIBUTED, V.MAX_T_ABANDONED, V.MAX_T_ANSWERED, V.PC_N_ABANDOVED, V.PC_N_ANSWERED, V.SERVICE_FACTOR, V.N_ABANDONED, V.N_ANSWERED, V.N_DISTRIBUTED, V.N_DISTRIB_IN_TR, V.N_ENTERED, V.N_ABANDONED_IN_TR, V.T_ABANDONED, V.T_ANSWERED, V.T_DISTRIBUTED, V.PC_N_DISTRIB
FROM DATAMART01.T_QUEUE_DAY T
INNER JOIN DATAMART01.V_QUEUE_DAY V
INNER JOIN DATAMART01.O_QUEUE_DAY O ON V.OBJECT_ID = O.OBJECT_ID
ON T.TIME_KEY = V.TIME_KEY AND O.OBJECT_NAME IN
( SELECT DISTINCT CONCAT (D.NAME,'@NIVR') AS VQNIVR
FROM (CONFIG02.CFG_GROUP G
CONFIG02.CFG_DN D INNER JOIN CONFIG02.CFG_DN_GROUP DG ON
D.DBID = DG.DN_DBID)
INNER JOIN CONFIG.CFG_GROUP G ON
G.DBID = DG.GROUP_DBID
INNER JOIN O.OBJECT_NAME ON VQNIVR)
WHERE G.NAME = 'T_FLY' AND T.DATE_YYYYMMDD = '20080122');

 

[genomon]

Unless this is some kind of test, please post the error you are getting...

All I ask is a chance to prove that money can't make me happy.

 

[PappaG]

not a test my first attempt at a nested query but changed it so many times and cant get it to run. I am using dbvis and the error i get is missing parethesis

 

[PHV]

This is not JetSQL syntax ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

Especially CONCAT

All I ask is a chance to prove that money can't make me happy.