像这样吗?
Insert INTO TableA (col1, col2,col3,col4) SELECt b.col1, c.col2, d.col3, @myparam FROM TableB as b INNER JOIN TableC as c ON b.id = c.id INNER JOIN TableD as d on c.id = d.id

像这样吗?
Insert INTO TableA (col1, col2,col3,col4) SELECt b.col1, c.col2, d.col3, @myparam FROM TableB as b INNER JOIN TableC as c ON b.id = c.id INNER JOIN TableD as d on c.id = d.id