使用SELECT执行INSERT以插入多个记录

INSERT
MainTable_Option
(
MainTableID,
OptionID
)
SELECt
d.ID,
o.OptionId
FROM
DodgyOldTable d
INNER JOIN Option o ON
(d.OptionVal1 = ‘Y’ AND o.OptionDesc = ‘OptionVal1’) OR
(d.OptionVal2 = ‘Y’ AND o.OptionDesc = ‘OptionVal2’) OR
(d.OptionVal3 = ‘Y’ AND o.OptionDesc = ‘OptionVal3’)