SELECT * FROM stemcount LEFT JOIN stemlocation USING (stemcount_id) ;