- 论坛徽章:
- 0
|
SELECT 客户姓名,客户卡号,网点代码,网点名称,申请金额,b.`Stat` FROM fund
LEFT JOIN b ON b.Card_no=fund.客户卡号
LEFT JOIN usergroup c ON c.UserAccount=b.Emp_Id
WHERE 是否C类收费='非C类' AND (交易类型='一般认购' OR 交易类型='一般申购');
========================================================
SELECT *,rank FROM (
SELECT pmm_tmp.*,@rownum:=@rownum+1 ,
IF(@pdept=pmm_tmp.object_id,@rank:=@rank+1,@rank:=1) AS rank,
@pdept:=pmm_tmp.object_id
FROM (
SELECT * FROM c_opt_indivemprela ORDER BY object_id ASC ,eff_dt DESC
) pmm_tmp ,(SELECT @rownum :=0 , @pdept := NULL ,@rank:=0) a ) AS b
WHERE objectid_type='0' AND rank='1';
如何将第二段的结果集用于第一段左关联呢 |
|