Re: SELECT ... WHERE ... IN (SELECT ...) -> - Mailing list 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