Date: 12/01/05 (MySQL Communtiy)    Keywords: no keywords

Hi, everyone!

I have several tables, containing info about users. There're two keys 'id' and 'name'.
I need to output all information about some user on administrator's demand having these two keys in WHERE clause.
The problem is the user could have some fields in some tables empty, so when SELECT finds such fields it returns 'Empty set' to me and I wish it to display any existing information about distinct user nevertheless.
Does somebody know how this problem could be solved?

Source: http://www.livejournal.com/community/mysql/74579.html