SELECT t1.* FROM t1 JOIN t2 ON ( t1.t2_id = t2.id AND t1.date_field::TIMESTAMP = t2.datetime_field AT TIME ZONE 'Europe/London' )