SQL question

SQL question

Hello, 

For example:
SELECT words.id, files.id FROM words,files WHERE w=$1 and host=$2 and name=$3;

If words table has $1 and files table has $2 and $3 then I'll get
result like
id1 id2
-------
223 235

But if words or files does not have corresponding info then it will
return empty relation.

Is it possible get something like
id1 id2
--------
234 NULL

Thank you for info.

-- 
Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga", 
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744