Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
debian 9;Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
-
5.5.59, 10.0.34
Description
SELECT t.SID, t.NAME,t.ID_NO,t.MOBILE,r.credit_status,t.amount,r.cust_active_amount,t.END_TIME,t.FILE_NAME |
FROM (select sid,name,id_no,recommend_id_no,mobile,amount,end_time,FILE_NAME from tc_white_list |
WHERE recommend_id_no='ybr' ) t |
LEFT JOIN (SELECT credit_status,id_no,cust_active_amount |
from datacqsn.tc_credit_request WHERE sid in(SELECT max(sid) |
from datacqsn.tc_credit_request where credit_status>'0' GROUP BY id_no)) r |
on t.ID_NO=r.id_no |
table t have two rows ,r have 0 rows ,result have no rows
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
Activity
| Transition | Time In Source Status | Execution Times |
|---|
|
2d 6h 51m | 1 |
|
18d 3h 41m | 1 |
|
1d 4h 32m | 1 |
|
61d 17h 14m | 1 |
|
1d 16h 15m | 1 |