www.hkvforums.com

SELECT (Period_Diff(Date_Format(CurDate(), '%y%m'), Date_Format(parcelas.data,
'%y%m')) - parcelas.prestacoes_pagas) AS num_meses_atrasados,
Period_Diff(Date_Format(CurDate(), '%y%m'), Date_Format(parcelas.data,
'%y%m')) AS num_meses,
cliente.endereco AS endereco,
cliente.cpf AS cpf,
parcelas.prestacoes_pagas AS prestacoes_pagas,
parcelas.data AS data,
cliente.escritorio AS escritorio,
cliente.nome AS nome
FROM parcelas JOIN
cliente ON cliente.id = parcelas.id_cliente
GROUP BY cliente.endereco,
cliente.cpf,
parcelas.prestacoes_pagas,
parcelas.data,
cliente.escritorio,
cliente.nome
HAVING (Period_Diff(Date_Format(CurDate(), '%y%m'), Date_Format(parcelas.data,
'%y%m')) - parcelas.prestacoes_pagas) >= 2 AND cliente.escritorio =
'$_SESSION[EW_SESSION_USER_NAMES2]'

With PHPMaker v7 but it works in v9 of the following error when running a search:
Failed to execute SQL. Error: Unknown column 'cliente.endereco' in 'where clause'

You cannot use PHP variables in Custom View.

So rather PHPMaker v(7) where everything works !

No, it should not work in v7 neither.

Yes friend, this query works perfectly in PHPMaker v (7)

oliveira wrote:
With PHPMaker v7 but it works in v9 of the following error when running a search:
Failed to execute SQL. Error: Unknown column 'cliente.endereco' in 'where clause'

Perhaps in v9 you have modified your project by adding a filter somewhere that involved cliente.endereco field, whereas the SQL doesn't.

Alternatively, recheck your SQL above
cliente.endereco AS endereco,

should be
cliente.endereco,