菜鸟遇到紧急问题求救啊！

[rubber365]

我有两个表：
ArtWashPrintSpeci 含有字段(Specification,Price)
ArtWashPrintSpeciInfo 含有字段（ShopName,Specification,Price）

我要向ArtWashPrintSpeciInfo 中插入记录，ShopName和Specification是输入的，而Price要根据Specification从ArtWashPrintSpeci中查出。
如何用一条SQL语句完成这个操作那？
这样，为什么不行呢？
Insert into ArtWashPrintSpeciInfo(UniteShopUserName,Specification,Price) values('aaa','5',(select Price=Price from ArtWashPrintSpeci where Specification='5'))

[messinglong]

up

[lqxmm]

Insert into ArtWashPrintSpeciInfo select 'aaa' as UniteShopUserName,'5' as Specification,Price from ArtWashPrintSpeci where Specification='5'
就可以了

[愉快的登山者]

Insert into ArtWashPrintSpeciInfo
select 'aaa','5', Price from ArtWashPrintSpeci where Specification='5'

[psxfghost]

Insert into ArtWashPrintSpeciInfo(UniteShopUserName,Specification,Price) （select 'aaa','5' ,Price from ArtWashPrintSpeci where Specification='5'))

[pengdali]

Insert ArtWashPrintSpeciInfo(UniteShopUserName,Specification,Price)

select 'aaa','5',Price from ArtWashPrintSpeci where Specification='5'

[cxingh]

up