Message-ID: <36AA6252.18DFF5E1@gbcomputers.com>
Date: Sat, 23 Jan 1999 15:59:14 -0800
From: Gregg Berkholtz <gregg@gbcomputers.com>
Organization: GB Computers
MIME-Version: 1.0
To: David Hartwig <daybee@bellatlantic.net>
CC: Access Developer listserv <accessd@mtgroup.com>,
	Postgres interface list <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] MS Access 97 and Pass-through SQL
References: <007f01be4729$98382480$027dc497@daveh>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I was aware of the jet engine, but it is so _SLOW_ that I was hoping to maybe
find a way to speed it up. The only thing that I could think of was
pass-through... Which, of course no longer allowed me to do most joins. :-(

I am just beginning to learn SQL and have been given this project to work on,
not knowing that much about SQL has forced me to build the queries in the
builder and then convert them to an SQL pass-through.

Does anyone know of an equivalent SQL statement/syntax that I could use instead
of INNER JOINS with PostgreSQL.

This is the statement as it comes out of Access (what it is supposed to do is
query the database getting the relevant information about all open Trouble
Tickets from multiple fields):

SELECT tblTroubTick.troubTickID, tblTroubTick.troubTickNum,
[tblClientInfo]![firstName] & " " & [tblClientInfo]![lastName] AS
concatTblClientTbl, tblTroubTick.troubTickOpenDate,
tblTroubTickProblem.troubTickProblem, tblPriority.priority,
tblTroubTick.hoursInvested, [tblSupportPersonelInfo]![firstName] & " " &
[tblSupportPersonelInfo]![lastName] AS concatTblSupportPersonell,
tblTroubTick.troubTickLastUpdate, tblTroubTick.assetID,
tblTroubTickStatus.troubTickStatus
FROM tblSupportPersonelInfo INNER JOIN (tblPriority INNER JOIN
(tblTroubTickProblem INNER JOIN (tblClientLocation INNER JOIN (tblClientInfo
INNER JOIN (tblTroubTickStatus INNER JOIN tblTroubTick ON
tblTroubTickStatus.troubTickStatusID = tblTroubTick.troubTickStatusID) ON
tblClientInfo.clientID = tblTroubTick.clientID) ON tblClientLocation.locationID
= tblClientInfo.locationID) ON tblTroubTickProblem.troubTickProblemID =
tblTroubTick.troubTickProblemID) ON tblPriority.priorityID =
tblTroubTick.priorityID) ON tblSupportPersonelInfo.supportPersID =
tblTroubTick.supportPersID
WHERE (((tblTroubTickStatus.troubTickStatus) Not In ("CLOSED")));


Thanks for the help!

Gregg Berkholtz

David Hartwig wrote:

> Any legal PostgreSQL statement(s) should work.  However, I don't think
> multiple resultset are allowed.  The big thing is that you are avoiding the
> MS Jet Engine.  This will allow you access any non-standard functions and
> syntax available to PostgreSQL.
>
> If you don't know, Jet has many benifits.  Like performing outer joins and
> cross-tabulation.
>
> ----- Original Message -----
> From: Gregg Berkholtz <gregg@gbcomputers.com>
> To: Access Developer listserv <accessd@mtgroup.com>; Postgres interface list
> <pgsql-interfaces@postgreSQL.org>
> Sent: Saturday, January 23, 1999 3:08 PM
> Subject: [INTERFACES] MS Access 97 and Pass-through SQL
>
> >Does anyone know what pass-through SQL statements cannot be used with
> >PostgreSQL connections via ODBC.
> >I am running PostgreSQL 6.4.2.
> >
> >Thanks greatly!
> >
> >Gregg Berkholtz
> >
> >