高分求购sql语句

[HndyLiu]

表table
子段：id pid morder
1 0 1
2 1 1
3 1 2
4 0 2
5 0 3

需求：从表table里读出pid=0的所有记录，并且将所有pid=id.value全部读取出来，并按照morder排序

[zjcxc]

--什么意思?
select * from table wher pid=0

[HndyLiu]

select * from table wher pid=0

select * from where pid in (select * from table wher pid=0)

[HndyLiu]

读取所有PID=0的记录：select * from table wher pid=0

读取所有PID记录不为0的记录

[sunshareforever]

select * from table where id = pid and pid = '0' order by morder

[brook_huang]

pid=id.value?
select * from table wher pid=0 order by morder

[brook_huang]

select * from table wher pid<>0

[HndyLiu]

对啊
pid=0为主力
pid=id的值的为 它的替补
现在需要：将主力提取，并将它对应的替补放在它随后

[wzh1215]

select * from table where pid=0
union all
select * from table where pid=id
order by morder

[HndyLiu]

谢谢大家，

wzh1215(四脚蛇) ( )

select * from table where pid=0
union all
select * from table where pid=id
order by morder

语句报错：=号附近有语法错误

[wzh1215]

没有问题，有问题就可能是类型的问题了！
create table #table(id int,pid int,morder int)
insert #table values(1,0,1)
insert #table values(2,1,1)
insert #table values(3,1,2)
insert #table values(4,0,2)
insert #table values(5,0,3)

select * from #table where pid=0
union all
select * from #table where pid=id
order by morder

[monkeys]

select * from table order by pid,id