Thread: SQL question

SQL question

From
"Igor' Robul'"
Date:
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