relationshipJoin.sql

SELECT
  w.customer_id,
  b.*
FROM l
  INNER JOIN b ON l.id = b.lot_id
  LEFT JOIN w ON l.id = w.lot_id
                                AND w.customer_id = b.customer_id
WHERE b.customer_id = 17
#      AND b.active = 1

ORDER BY l.sale_ts ASC