title: SQL LEFT OUTER JOIN not working
body: <pre><code>SELECT
     s.SeatNo, BOOKING_ID
  FROM
     SEAT s 
  LEFT OUTER JOIN 
     BOOKING b ON (s.SeatNo = b.SeatNo) AND (plane_id = 'BEY101');
  </code></pre>
  
  <p>I have 5 planes and 150 seats for each plane. I want to show all seats (150) for the flight and the number of seats booked (let say 50) (i.e. 150 in the result set's first column and 50 in its second column).</p>