Hi Svein,

Yeah I was wondering about that part of the SQL. I wrote this a few years
ago.

What I am thinking is that perhaps the query is just taking ages when they
run it over the network, rather than the system actually hanging.

Stephen

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
Sent: Tuesday, August 10, 2004 12:47 PM


> Hi Stephen!
>
> No, to me it doesn't look right to mix implicit and explicit joins.
> Change to (just the FROM part of your query copied here)
>
> FROM BOOKBORROWERHISTORY BBH
> JOIN BOOK B ON B.BOOK_ID = BBH.BOOK_ID
> LEFT OUTER JOIN LOCATION L ON B.LOCATION_ID = L.LOCATION_ID
>
> Though something working from one PC and not from another doesn't
> sound like a SQL problem, so I'd start by checking whether anyone
> (including you) are using an incorrect client library (gds32.dll or
> fbclient.dll, if I remember correctly).
>
> Set



--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.262 / Virus Database: 264.5.0 - Release Date: 09/08/2004