Forum Discussion
Syndicate_Admin
Administrator
AdministratorError en SQL en postgresql en power bi advanced editor
Hola Tengo errror en sql. Estoy recibiendo este error. Mensaje de error: DataSource.Error: ODBC: ERROR [42601] ERROR: error de sintaxis en o cerca de "."; Error al ejecutar la consulta ...
SELECT rws.zu0_kod AS zu0_kod, rws.did_nr AS did_nr, rws.adm_var AS adm_var, rws.did_dat AS did_dat ,COUNT (1) AS eil_skaicius FROM (SELECT tab1.zu0_kod, tab1.did_nr, tab1.adm_var, tab1.did_dat FROM (SELECT id_vidp AS id_vidp2, zu0_kod AS zu0_kod, AS did_nr, adm_var AS adm_var, did_dat AS did_dat FROM a.vidp WHERE a.vidp.did_dat >= filterdate) tab1 LEFT OUTER JOIN a.vidp tab2 ON tab1.id_vidp2 = tab2.id_vidp) rws GROUP BY rws.zu0_kod, rws.did_nr, rws.adm_var, rws.did_dat¿Esta consulta funciona para usted en Postgre SQL Editor? ? Intente eliminar "." en eil.skaicius y reemplácelo por "_" y vea si funciona
Syndicate_AdminAdministrator
Administrator
SELECT rws.zu0_kod AS zu0_kod,
rws.did_nr AS did_nr,
rws.adm_var AS adm_var,
rws.did_dat AS did_dat
,COUNT (1) AS eil_skaicius
FROM (SELECT tab1.zu0_kod,
tab1.did_nr,
tab1.adm_var,
tab1.did_dat
FROM (SELECT id_vidp AS id_vidp2,
zu0_kod AS zu0_kod,
AS did_nr,
adm_var AS adm_var,
did_dat AS did_dat
FROM a.vidp
WHERE a.vidp.did_dat >= filterdate) tab1
LEFT OUTER JOIN a.vidp tab2
ON tab1.id_vidp2 = tab2.id_vidp) rws
GROUP BY rws.zu0_kod,
rws.did_nr,
rws.adm_var,
rws.did_dat
¿Esta consulta funciona para usted en Postgre SQL Editor? ? Intente eliminar "." en eil.skaicius y reemplácelo por "_" y vea si funciona
Syndicate_AdminAdministrator
AdministratorAdemás, al verificar más, parece que su consulta interna contiene un error
SELECT rws.zu0_kod AS zu0_kod,
rws.did_nr AS did_nr,
rws.adm_var AS adm_var,
rws.did_dat AS did_dat
,COUNT (1) AS eil_skaicius
FROM (SELECT tab1.zu0_kod,
tab1.did_nr,
tab1.adm_var,
tab1.did_dat
FROM (SELECT id_vidp AS id_vidp2,
zu0_kod AS zu0_kod,
[ColumnName is MISSING HERE] AS did_nr,
adm_var AS adm_var,
did_dat AS did_dat
FROM a.vidp
WHERE a.vidp.did_dat >= filterdate) tab1
LEFT OUTER JOIN a.vidp tab2
ON tab1.id_vidp2 = tab2.id_vidp) rws
GROUP BY rws.zu0_kod,
rws.did_nr,
rws.adm_var,
rws.did_dat