???????????????????

????1??????????л???????б???????￡?

?????

1
SELECT * FROM L_loan_info WHERE step_id=@step_id
????????@step_id????????????????????????

????2?????????????????????б????

?????

1
SELECT * FROM L_loan_info WHERE loan_id IN (SELECT DISTINCT loan_id<br> FROM l_tranct_proc WHERE step_id=@step_id)
????3?????????????????б?(??δ??????????)

????View Code

????????????????????????????????????????????????????

???????????????н??

????1????????????