Hello:
I am migrating a database used by a 3rd party application. It is running
fine with SAPDB 7.4. After importing data into MAXDB 7.5.0.24, a certain
module reported this error regarding an outer join. I would like to know
if this SQL contains some deprecated syntax? Thank you, Martin.
[-7068] (at 9): Outer join not allowed in this context; SQL=SELECT
Ci.id_cotiz_import,
Ci.nu_cotiz_importa,
Ci.fe_cotiz_importa,
Ci.id_status,
St.tx_status,
0.00 mn_compra,
'' tx_divisa,
dp.tx_dpto,
pr.nb_proveedor,
DECODE(St.co_status,'ENCOM','Calcular','') codigo
FROM
Cotiz_Import Ci,
Cotiz_Imp_compra Cic1,
cotiz_compra cc1,
Status St,
departamento dp,
proveedor pr
WHERE
Ci.id_status = St.id_status
AND
Ci.id_cotiz_import = Cic1.id_cotiz_import
AND
Cic1.id_cotiz_compra = cc1.id_cotiz_compra
AND
cc1.id_proveedor = pr.id_proveedor
AND
cc1.id_departamento = dp.id_departamento
AND
cc1.id_cotiz_compra = (SELECT
cc2.id_cotiz_compra
FROM
Cotiz_Imp_compra Cic2,
cotiz_compra cc2
WHERE
Cic2.id_cotiz_compra = cc2.id_cotiz_compra(+)
AND
Cic2.id_cotiz_import =
Cic1.id_cotiz_import(+)
AND ROWNO < 2 )
AND Ci.id_status = 1
GROUP BY
Ci.id_cotiz_import,
Ci.nu_cotiz_importa,
Ci.id_status,
Ci.fe_cotiz_importa,
St.tx_status,
dp.tx_dpto,
pr.nb_proveedor,
St.co_status
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
