id number primary key,
name varchar(20),
sunid number
)
insert into category values(1,'aa0',0)
insert into category values(2,'bb1',1)
insert into category values(3,'cc1',1)
insert into category values(4,'dd0',0)
insert into category values(5,'租桐ff1',3)
insert into category values(6,'gg1',3)
select b.id,b.name from category a join category b on a.id=b.sunid and a.id =1
结果:
id name
2 bb1
3 cc1
不知道楼主是不是纯蠢想要这种结弊裤坦果,这是使用自连接实现的
SELECT A.*,B.* FROM [Product] AS A, [CClass] AS B WHERE A.ClassID=B.ID And A.ClassID=" &CLng(ClassID) &" ORDER BY A.ID DESC这是耐袜表的现有数据:
通过sql查询结昌敏激果:
sql:
select yi.*
from(select distinct parent_id pid from products a where a.`parent_id`>0) er
left join products yi on er.pid=yi.`id`
先通过查询表中parent_id不为空的(表中parnet_id字段类型设置的整型同拿缓id,所以直接用>0判断了),然后使用distinct查重,获取对应的parent_id,再去关联该表查询出结果即可。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)