SELECT t1.*, t2.fam_comName FROM nc_list_harry as t1 LEFT JOIN family_comName as t2 on UPPER(t1.family)=UPPER(t2.family) where 1 ORDER BY t1.sort_order Error #3Table 'herps.nc_list_harry' doesn't exist