select查询

[kart15]

表News_Article
ArticleID Title Content RootID CategoryID
1 化繁为简的管理艺术 dsdss 1 1

表News_category
CategoryID CategoryName ParentID
1 ddddd 1

请问大家我想查出这个数据
ArticleID Title Content RootID CategoryID CategoryName
1 化繁为简的管理艺术 dsdss 1 1 ddddd

我这条select语句怎么写啊?

[jiang_jiajia10]

select s.*,b.CategoryName from News_Article as s left join News_category as b on s.CategoryID =b.CategoryID where s.CategoryID=1

[木偶哈哈哈]

[Quote=引用 5 楼 jiang_jiajia10 的回复:]
SQL code
select s.*,b.CategoryName from News_Article as s left join News_category as b on s.CategoryID =b.CategoryID where s.CategoryID=1
[/Quote]
是这样的！

[greatverve]

基本功这么差，还不赶快看点基础的书？

[Robin]

 
select * from News_Article,News_category where News_Article.CategoryID=News_category.CategoryID 

[mengxj85]

[Quote=引用 5 楼 jiang_jiajia10 的回复:]
SQL code
select s.*,b.CategoryName from News_Article as s left join News_category as b on s.CategoryID =b.CategoryID where s.CategoryID=1
[/Quote]
建议楼主好好学习一下T-SQL

[wuyq11]

select a.*,(select CategoryName from News_category where a.CategoryID =CategoryID
) as CategoryName from News_Article a

[zytp]

SELECT *
FROM News_Article INNER JOIN News_Category ON News_Article.Categoryid = News_category.Categoryid

[kart15]

还要CategoryID=1

[Adechen]

[Quote=引用 2 楼 zytp 的回复:]
SELECT *
FROM News_Article INNER JOIN News_Category ON News_Article.Categoryid = News_category.Categoryid
[/Quote]
就是这样的