Unknown column 'dv.detail_id' in 'on clause' select dv.*, dn.name, m.full_path, m.thumb_path, m.med_path from detail_value dv, detail_name dn left join media m on (dv.detail_id = m.record_id and m.record_type='detail_value') where dv.dn_id = dn.dn_id