SQL 语句解析:从两个表中选择特定列并分配到变量
This SQL statement selects specific columns (create_inst_no, create_teller_no, create_time, cust_no, disburse_date, financing_model) from two tables (tb_con_payout_info_detail and tb_con_contract) and assigns their values into variables (v_create_inst_no, v_create_teller_no, v_create_time, v_cust_no, v_disburse_date, v_financing_model). The WHERE clause filters the records based on the condition that the contract_no in the first table matches the contract_num in the second table, and the payout_info_detail_id in the first table matches the value of a variable named v_old.payout_info_detail_id.
原文地址: https://www.cveoy.top/t/topic/mQNW 著作权归作者所有。请勿转载和采集!