两张有关联的表的合并查询

  use  database

   select    NewsCategoryInfo.NewsCategoryName as 新闻种类, NewsInfo.NewsTitle  as 新闻标题 From NewsCategoryInfo inner joinNewsInfo on NewsCategoryInfo.NewsCategoryID= NewsInfo.NewsCategoryID

   delete  from NewsInfo where NewsID=id

   insert  into NewsInfo(NewsTitle ) value("国际news")

   update  NewsInfo set   NewsTitle=" 娱乐新闻“ where NewsID=3