esta quiery falla, en que?
Publicado por Patricia (1 intervención) el 04/07/2006 17:29:33
Hola,
Alguno me podria decir porque la primera query da error y la segunda esta OK?
He redactado las dos consultas para que , en teoria,devuelban lo mismo.
Gracias,
1 // Primera consulta da fallo
SELECT A.PERIOD_END_DATE,
A.SEQUENCE_NUM,
A.LOAN_SCHEME,
A.EIR_ELEMENT_ID
FROM ( SELECT PERIOD_END_DATE,
ACCOUNT_REFERENCE,
SEQUENCE_NUM,
LOAN_SCHEME,
. EIR_ELEMENT_ID,
ALLOC_STATUS_TYP,
TRANSACTION_AMT,
FROM EIR_TRANS_FC
WHERE EIR_ELEMENT_ID=11 AND
ALLOC_STATUS_TYP=1 FOR READ ONLY) A,
(SELECT .ACCOUNT_REFERENCE,
SEQUENCE_NUM,
LOAN_SCHEME,
PERIOD,
ERC_AMT,
YEAR_MONTH
FROM EIR_CASH_FLOW_F
WHERE YEAR_MONTH = 200605 FOR READ ONLY WITH RS) B
WHERE A.ACCOUNT_REFERENCE= B.ACCOUNT_REFERENCE AND
A.SEQUENCE_NUM=B.SEQUENCE_NUM AND
A.LOAN_SCHEME=B.LOAN_SCHEME;
2 // Segunda consulta
SELECT A.PERIOD_END_DATE,
A.SEQUENCE_NUM,
A.LOAN_SCHEME,
A.EIR_ELEMENT_ID
FROM EIR_TRANS_FC A, EIR_CASH_FLOW_F B
WHERE A.EIR_ELEMENT_ID=11 AND
A.ALLOC_STATUS_TYP=1 AND
B.YEAR_MONTH = 200605 AND
A.ACCOUNT_REFERENCE= B.ACCOUNT_REFERENCE AND
A.SEQUENCE_NUM=B.SEQUENCE_NUM AND
A.LOAN_SCHEME=B.LOAN_SCHEME;
Alguno me podria decir porque la primera query da error y la segunda esta OK?
He redactado las dos consultas para que , en teoria,devuelban lo mismo.
Gracias,
1 // Primera consulta da fallo
SELECT A.PERIOD_END_DATE,
A.SEQUENCE_NUM,
A.LOAN_SCHEME,
A.EIR_ELEMENT_ID
FROM ( SELECT PERIOD_END_DATE,
ACCOUNT_REFERENCE,
SEQUENCE_NUM,
LOAN_SCHEME,
. EIR_ELEMENT_ID,
ALLOC_STATUS_TYP,
TRANSACTION_AMT,
FROM EIR_TRANS_FC
WHERE EIR_ELEMENT_ID=11 AND
ALLOC_STATUS_TYP=1 FOR READ ONLY) A,
(SELECT .ACCOUNT_REFERENCE,
SEQUENCE_NUM,
LOAN_SCHEME,
PERIOD,
ERC_AMT,
YEAR_MONTH
FROM EIR_CASH_FLOW_F
WHERE YEAR_MONTH = 200605 FOR READ ONLY WITH RS) B
WHERE A.ACCOUNT_REFERENCE= B.ACCOUNT_REFERENCE AND
A.SEQUENCE_NUM=B.SEQUENCE_NUM AND
A.LOAN_SCHEME=B.LOAN_SCHEME;
2 // Segunda consulta
SELECT A.PERIOD_END_DATE,
A.SEQUENCE_NUM,
A.LOAN_SCHEME,
A.EIR_ELEMENT_ID
FROM EIR_TRANS_FC A, EIR_CASH_FLOW_F B
WHERE A.EIR_ELEMENT_ID=11 AND
A.ALLOC_STATUS_TYP=1 AND
B.YEAR_MONTH = 200605 AND
A.ACCOUNT_REFERENCE= B.ACCOUNT_REFERENCE AND
A.SEQUENCE_NUM=B.SEQUENCE_NUM AND
A.LOAN_SCHEME=B.LOAN_SCHEME;
Valora esta pregunta
0