title: could I remove this code and put a full outer join for this example?
body: <pre><code>$sql = 'SELECT * FROM t1
            LEFT JOIN t2 ON watchdog.wid = t1.wid  
            UNION
            SELECT * FROM t1
            RIGHT JOIN t2 ON watchdog.wid = t1.wid
            LIMIT ' . $number . ' OFFSET ' . $number;
    $result = db_query($sql);
  </code></pre>
  
  <p>Could anyone help on how this will be written with FULL OUTER JOIN??</p>