if(($startdate1!="") && ($enddate1!="")) {
$strSql_Condition.=" and eb_limitdate >= to_date('$startdate1','YYYY/MM/DD') and eb_limitdate <= to_date('$enddate1','YYYY/MM/DD')";$sql = "select * from escustomers_base left join escustomers_extent on $strSql_Condition"
$strSql_Condition.=" and eb_limitdate >= to_date('$startdate1','YYYY/MM/DD') and eb_limitdate <= to_date('$enddate1','YYYY/MM/DD')";$sql = "select * from escustomers_base left join escustomers_extent on $strSql_Condition"
SQL语句支持嵌套查询:比如SELECT eb_id FROM 会员表 WHERE 最后时间条件 IN (SELECT eb_id FROM 续费表 WHERE 过期时间条件)
至于要取得那个记录(假如有多个记录),你可以使用升序或者降序排列去获得啊,如果要判断会员是否在续费表有记录等,你都可以另行判断的。实在不行还可以做二次查询(两次单表查询)
weisun (巍巍)
晕
被骗了,在这又变成“小弟”?
没分过了几分钟又有分了??
......
http://expert.csdn.net/Expert/topic/2927/2927383.xml?temp=.6015283