title: How do I print out 'NULL' or '0' values for column values when an element isn't found?
body: <p>I need to loop through a set of values (less than 10) and see if they are in a table. If so, I need to print out all of the record values, but if the item doesn't exist, I still want it to be included in the printed result, although with NULL or 0 values. So, for example, the following query returns:</p>
  
  <pre><code>select * 
    from ACTOR 
   where ID in (4, 5, 15);
  </code></pre>
  
  <p><PRE>
  +----+-----------------------------+-------------+----------+------+
  | ID | NAME                        | DESCRIPTION | ORDER_ID | TYPE |
  +----+-----------------------------+-------------+----------+------+
  |  4 | [TEST-1]                    |             |        3 | NULL |
  |  5 | [TEST-2]                    |             |        4 | NULL |
  +----+-----------------------------+-------------+----------+------+
  </PRE>
  But I want it to return
  <PRE>
  +----+-----------------------------+-------------+----------+------+
  | ID | NAME                        | DESCRIPTION | ORDER_ID | TYPE |
  +----+-----------------------------+-------------+----------+------+
  |  4 | [TEST-1]                    |             |        3 | NULL |
  |  5 | [TEST-2]                    |             |        4 | NULL |
  |  15| NULL                        |             |        0 | NULL |
  +----+-----------------------------+-------------+----------+------+
  </PRE></p>
  
  <p>Is this possible?</p>