怎么把查出来的值赋值给另一个表的其中一个列

Question

1. select d.di_Id,d.sl_SerialNumber,d.sl_Money,s.s_Name,d.di_Time,d.di_Remark from tab_disbursements d join tab_staff s on d.s_Id=s.s_Id limit #{pageIndex},#{limit}

2.SELECT SUM(pd_Subtotal)FROM  tab_purchasedetails WHERE sl_SerialNumber=2

希望sql语句2查出来的数据赋值给sql语句1中的sl_Money列。求大佬解答

 

Answer 1

select d.di_Id,d.sl_SerialNumber,(SELECT SUM(pd_Subtotal) FROM tab_purchasedetails WHERE sl_SerialNumber=d.sl_SerialNumber) sl_Money,s.s_Name,d.di_Time,d.di_Remark from tab_disbursements d join tab_staff s on d.s_Id=s.s_Id limit#{pageIndex},#{limit}