Re: SELECT ... WHERE ... IN (SELECT ...) ->

From: Sergey Suleymanov <solt(at)eatpbank(dot)ru>
To: Russian PostgreSQL community <pgsql-ru-general(at)postgresql(dot)org>
Subject: Re: SELECT ... WHERE ... IN (SELECT ...) ->
Date: 2006-12-05 06:31:13
Message-ID: 87d56y26ry.fsf@su.eatpbank.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ru-general

>>>>> Anton writes:

Anton> explain analyze SELECT collect_time FROM n_traffic, n_logins
Anton> WHERE collect_time > '1970-01-01 00:00:00' AND
Anton> n_traffic.login_id = n_logins.login_id AND account_id = '1655'
Anton> ORDER BY collect_time LIMIT 1

А если таки явно нарисовать join ?

SELECT n_traffic.collect_time
FROM n_logins
JOIN n_traffic ON (n_traffic.login_id = n_logins.login_id AND
n_traffic.collect_time > '1970-01-01 00:00:00')
WHERE n_logins.account_id = '1655'
ORDER BY n_traffic.collect_time, n_traffic.login_id LIMIT 1

--
Sergey Suleymanov

In response to

Responses

Browse pgsql-ru-general by date

  From Date Subject
Next Message Anton 2006-12-05 06:47:11 Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )
Previous Message Alexander M. Pravking 2006-12-04 20:31:59 Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... )