postgresql7.1 select u.email as user_email, id.email as id_email from ec_user_identification id left join cc_users u using (user_id) where id.user_identification_id=:user_identification_id