Java开发网 - A question about find

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

A question about find

gaoxt1983

发贴: 67
积分: 0

于 2006-11-08 17:23

I have three table : table A has many table B, table B has many table C, sometimes , I want to find all A 's data , and each A's row , I want to find all the B which meet the condition, which is a iteration. But my companymates warning me not to do that, because of effective. I should do that :
select max(a.position_name) as pn, max(c.name) as dn,
count(*) as c from position a, resume b, department c
where a.id = b.position_id and a.department_id = c.id
group by b.position_id

I think this method is sick , but I don't know better, would anyone help me?

why edited on 2006-11-08 19:24

话题树型展开

人气	标题	作者	字数	发贴时间
10201	A question about find	gaoxt1983	568	2006-11-08 17:23
8001	Re:A question about find	why	74	2006-11-08 19:26
7991	Re:A question about find	gaoxt1983	109	2006-11-08 21:45
8667	Re:A question about find	why	67	2006-11-09 07:05

已读帖子

新的帖子

被删除的帖子