Hi all,
I have this problem:
This sample query create with Access
SELECT figure.*, utenti.ragione_sociale
FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
via-psqlODBC reports this
ERROR: The field being ordered by must appear in the target list'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
Postgres executes this sql query (I find this in Psqlodbc.log file) :
SELECT figure.oid,utenti.azienda
FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
Why is there ORDER BY CLAUSE ?
Why is there only "figure.oid" instead of "figure.*" in SELECT
arguments ??????
Best regards,
Marco Pollachini
Sferacarta mailto:sferac@bo.nettuno.it