Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

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

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 A question about find
gaoxt1983





发贴: 67
积分: 0
于 2006-11-08 17:23 user profilesend a private message to usersearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
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


话题树型展开
人气 标题 作者 字数 发贴时间
8729 A question about find gaoxt1983 568 2006-11-08 17:23
6909 Re:A question about find why 74 2006-11-08 19:26
6889 Re:A question about find gaoxt1983 109 2006-11-08 21:45
7418 Re:A question about find why 67 2006-11-09 07:05

flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2018 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号
客服电话 0592-8750026    客服信箱 714923@qq.com    客服QQ 714923