Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

IDENTIFICADOR INVALIDO

estou tentanto executar o select abaixo, porém, ocorre erro quando chega no segundo select. O erro é identificador inválido. Estou conectando no Oracle.

SELECT


A.NUSOL

AS NR_SOLICITACAO,


D.CDSEQSOL

  AS SEQ,


D.NUPED

AS OC,


D.SICOMP

AS COMPRADOR,


A.CDPRO

AS COD_PROD,


B.DEPRO

AS PRODUTO,


A.DECOMP

AS COMPLEMENTO,


A.DEDIM

AS DIMENSOES,


D.QTSOL

AS QT_SOLIC,


D.QTPED

AS QT_PEDIDA,


C.NUSOLINT||'-'||A.CDDES1||'/'||A.CDDES2||'-'||A.CDDES3 AS DESENHO,


PCH

'||F.PCH AS PCH,


C'


AND

A.DTENTREGA > '01-jul-2012'


AND

A.CDPRO = B.CDPRO


AND

A.NUSOL = C.NUSOL


AND

A.CDPRO = D.CDPRO


AND

A.NUSOL = D.NUSOL


AND

A.NUPRJ = E.NUPRJ


AND

E.NUPED = F.NUPED


ORDER

BY A.NUSOL,D.CDSEQSOL;


SELECT


CMPITS.NUSOL,

CMPITS.CDSEQSOL,CMPITS.CDPRO, CMPITS.QTSOL,


CMPITS.QTPED,

CMPITS.NUPED,CMPITS.DTNECES, CMPITS.IDSITITE,


CMPITS.CDUSUA,

CMPITS.DEOBSP,


CADPRO.DEPRO,


CMPSOC.NUSOL,

CMPSOC.DTSOL, CMPSOC.DEOBS,CMPSOC.CDUSUA


FROM


IDS.CMPITS

,


IDS.CADPRO

,


IDS.CMPSOC


WHERE

CMPITS.NUSOL = CMPSOC.NUSOL


AND

CMPSOC.DEOBS <> 'Solicitação de compra a partir da lista de materiais, para itens com Origem C-compra'


AND

CMPITS.CDPRO = CADPRO.CDPRO

Community Browser