SQL Joins
*********

Left Outer
==========

::

  SELECT
      m.id,
      m.date,
      m.product_qty,
      product_uom.name,
      m.location_id,
      m.location_dest_id,
      m.name,
      m.picking_id,
      m.state
      FROM stock_move m
      LEFT OUTER JOIN product_uom
          ON m.product_uom = product_uom.id
      WHERE
          m.location_id = 12 OR m.location_dest_id = 12
      ORDER BY m.id DESC