Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA19751 for ; Mon, 6 Jul 1998 16:49:36 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id QAA19134 for pgsql-interfaces@postgreSQL.org; Mon, 6 Jul 1998 16:28:43 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA06731; Mon, 6 Jul 1998 16:25:10 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA51400; Mon, 6 Jul 1998 16:25:09 -0400 Message-Id: <35A133DB.CFE63868@insightdist.com> Date: Mon, 06 Jul 1998 16:30:19 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Sferacarta Software , pgsql-interfaces Subject: Re: [HACKERS] Access & Postgres References: <17501.980703@bo.nettuno.it> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit This question may be better posted on the interfaces list. See: http://www.insightdist.com/psqlodbc Visit the FAQ. It is one of the last items listed. Sferacarta Software wrote: > 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