SELECT * FROM "stemCount" LEFT JOIN "stemLocation" USING ("STEMCOUNT_ID") ;