备忘:SQL多表内连接语法
select * from B_DiscountExecH EH
inner join B_DiscountExecD ED on EH.DiscountNo=ED.DiscountNo
inner join B_DiscountReg R on R.RegNo=ED.RegNo
inner join B_DiscountSett S on S.RegNo=ED.RegNo
select * from B_DiscountExecH EH
inner join B_DiscountExecD ED on EH.DiscountNo=ED.DiscountNo
inner join B_DiscountReg R on R.RegNo=ED.RegNo
inner join B_DiscountSett S on S.RegNo=ED.RegNo