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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
