Обсуждение: Access & Postgres

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