高级查询的sql语句该怎么写
1个回答
2017-01-15
展开全部
高级查询的sql语句该怎么写
select id,title,(select StyleName from NewsStyle where News.StyleId=NewsStyle.StyleId) as StyleName,(select TypeName from NewsType where News.TypeId=NewsType.TypeId) as TypeName from News
select id,title,(select StyleName from NewsStyle where News.StyleId=NewsStyle.StyleId) as StyleName,(select TypeName from NewsType where News.TypeId=NewsType.TypeId) as TypeName from News
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询