In the diagram below there is a 1:1 relationship between 'DodgyOldTable' and 'MainTable'. Table 'Option' contains records with 'OptionVal1', 'OptionVal2' and 'OptionVal3' in the 'OptionDesc' field. I need to do an insert into MainTable_Option with a select from DodgyOldTable. Something like this:In the diagram below there is a 1:1 relationshi
阅读背景：
使用SELECT执行INSERT以插入多个记录
来源：互联网
分享到：
