还是那个循环递归,又有新的需求
前面的问题都已解决,先谢谢了!
http://community.csdn.net/Expert/topic/3778/3778627.xml?temp=.2893335
现在有个新的需求,也很变态:
有个主表 tbl_lcinfo:
lcid dealtime 其他字段 ...
-------------------- ------------------------ ----------
20050120153336359959 2005-01-26 12:41:49.000
20050124145844968972 2005-01-24 14:58:44.000
20050124150749109982 2005-01-24 15:07:49.000
20050124152907140795 2005-01-24 15:29:07.000
20050124162418734220 2005-01-24 16:24:18.000
20050125093058656827 2005-01-25 09:30:58.000
20050125093221968158 2005-01-25 09:32:21.000
20050125093343203803 2005-01-25 09:33:43.000
20050125093422484710 2005-01-25 09:34:22.000
关系表:tbl_LcAssociation:
Lc1 Lc2 AssociationType
------------------------------------------------
20050131164410984641 20050131164432421370 05
20050131164410984641 20050131164543968868 02
20060131171500890142 20060131171220921358 08
20050124145844968972 20050125173637609394 04
20050124145844968972 20050125173626546785 04
20050124145844968972 20050125173615531281 04
20050124145844968972 20050125173602046303 04
20050124145844968972 20050125173545109045 01
20050124145844968972 20050125174025859974 04
20050125151927031220 20050126142401562322 05
20050125105700468193 20050126142854328194 04
20050126135747890253 20050125173156718720 05
20050203142012218583 20050203141830562810 05
20050125100042859651 20050125093343203803 04
20050125173451609257 20050125094929281422 04
如果在一个时间范围(对应dealtime),查询tbl_lcinfo,
那么查出来的lcid有两种可能:
1.用[f_id] 查不到记录;
2.用[f_id] 可以查到一组对应关系记录。
现在想要的结果是,查询tbl_lcinfo,
满足1.的结果需要;
满足2.的结果,只要他查出的一组对应关系记录中dealtime最小的那一条就可以了。