SELECT * FROM taxonimportance LEFT JOIN stemcount USING (taxonimportance_id) ;