两表根据两字段关联即select distinct b.type_name from news a,news_type b where a.news_type_id= b.type_id and a.news_type_id = '1'
