在mysql中通过某个字段连接两张数据库表

SELECT community_news.id, community_news.category_id, community_news.imgs_count," +
  s" community_news.source_id, community_news.STATUS, community_news.admin_id, " +
  s"community_news.author_type, community_news.rss_id, community_news.is_in_whitelist, " +
  s"community_news.publish_type, community_show_tag.weight, community_show_tag.tag_id FROM " +
  s"community_news LEFT JOIN community_show_tag ON community_news.id = community_show_tag.item_id " +
  s"where community_show_tag.item_id is not null and and community_show_tag.is_semantic=1

表为community_news和community_show_tag