这个insert怎么写啊? 谢谢!

Question

有三个表
employee表 
employeeId(主键)
employeeName
==============
date 表      
dateId(主键)
dateName
====================
aa 表 
employeeID(主键)
dateID(主键)
aaString
---------------------
如果我有一个三个参数employeeName,dateName,astrings,
怎么插入aa表里?
需要调出 employeeID,dateID,还要加入astrings~

Answer 1

insert into aa select employeeId = (select employeeId from employee where employeeName = @employeeName),
                      dateID     = (select dateID from date where dateName = @dateName),
                      aaString   = @astrings