Re: Join several tables (to fetch user info), but one of them is optional (user avatar) - Mailing list pgsql-general

Thank you, I've ended up with:

# select
        u.uid,
        /* u.pass, */
        f.filename as avatar,
        (g.field_gender_value='Female') as female,
        c.field_city_value as city
from
        drupal_users u LEFT OUTER JOIN drupal_file_managed f on
(u.picture=f.fid),
        drupal_field_data_field_gender g,
        drupal_field_data_field_city c
where
        u.name='mvp' and
        g.entity_id=u.uid and
        c.entity_id=u.uid
;
  uid  | avatar | female |     city
-------+--------+--------+--------------
 18539 |        | f      | Moscow
(1 row)

I wonder though what is the syntax if I wanted
the other 2 tables (drupal_field_data_field_gender
and drupal_field_data_field_city) to be joined
as a "left outer join" as well?

Regards
Alex