On Thu, Jun 30, 2005 at 06:03:09PM +0300, Bobi Ivanov wrote:
>
> SELECT
> billingplans.id AS plan_id,
> billingplans.description as plan_name
> FROM (billingplans inner join billingplans_lots
> on billingplans.id = billingplans_lots.plan_id) inner join resellerlots
> on billingplans_lots.lot_id = resellerlots.lotid
> WHERE resellerlots.lot_desc = 45678 and resellerlots.resellerid = 1000
>
> and this is what I get:
>
> row number -1 is out of range 0..-1
> Total query runtime: 40 ms.
> Data retrieval runtime: 30 ms.
> 0 rows retrieved.
>
> I checked this through psql and:
>
> plan_id | plan_name
> ---------+-----------
> (0 rows)
I get the same result (zero rows) in psql; that appears to be
correct, given the join conditions and the WHERE clause. Maybe
Andreas or somebody else can test the query with pgAdmin.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
