请高手帮忙!!!
有两个表结构如下:
categories表
categories_id parent_id
1 0
2 0
3 0
4 1
5 1
6 1
7 2
8 2
9 2
10 3
11 3
12 3
categories_desction表
categories_id categories_name
1 A
2 B
3 C
4 Aa
5 Ab
6 Ac
7 Ba
8 Bb
9 Bc
10 Ca
11 Cb
12 Cc
能否通过一条语句得到以下的结果:
categories_id parent_id categories_name
1 0 A
4 1 Aa
5 1 Ab
6 1 Ac
2 0 B
7 2 Ba
8 2 Bb
9 2 Bc
3 0 C
10 3 Ca
11 3 Cb
12 3 Cc
[解决办法]
沙發
[解决办法]
select a.categories_id,a.parent_id,b.categories_name
from categories a , categories_desction b
where a.categories_id = b.categories_id
[解决办法]
一个问题开两个贴
[解决办法]
select categories.categories_id,categories.parent_id,categories_desction.categories_name from categories inner join categories_desction on categories.categories_id=categories_desction.categories_id order by categories_desction.categories_name
[解决办法]
这应该是最简单的两表连接.
select a.categories_id , a.parent_id , b.categories_name
from categories a , categories_desction b
where a.categories_id = b.categories_id
[解决办法]
leo_lesley(leo) 的排个序就可以了，比我的简单
[解决办法]
SELECT TOP 100 PERCENT dbo.categories.categories_id, dbo.categories.parent_id,
dbo.categories_desction.categories_name
FROM dbo.categories INNER JOIN
dbo.categories_desction ON
dbo.categories.categories_id = dbo.categories_desction.categories_id
ORDER BY dbo.categories_desction.categories_name
