SELECT t3.subfamily, t3.sub_fam_comName
FROM nc_list as t1
LEFT JOIN family_comName as t3 on UPPER(t1.family)=UPPER(t3.family)
where t1.species_status!='suppress'
group by subfamily
ORDER BY t1.subfamily Error #3Unknown column 't3.subfamily' in 'field list'