Version 8.1

[Diego <diego@xxxxxxxxxxxxxxxxx>]

Hi,

I have this SQL working very well in 8.0:

{SELECT *, tabpes.cod, tabpes.nome
FROM fincli_pesaut
WHERE TRUE
AND id_cli = '001/12'
AND id_pes = tabpes.id}

Why don´t work in 8.1?
ERROR:  missing FROM-clause entry for table "tabpes"

[]s
Diego Ziquinatti



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend