34,576
社区成员
发帖
与我相关
我的任务
分享又是一SQL问题
insert feedinme (receipt,goodsid,unit,quantity,storage,comefrom) values('aaa','bbbb','cccc',456,??????nquan,'eeee')这句乱写的
这句是没错的.如果上句中的?????nquan可不可以是一个语句,因为它的数值来源天另一个表,比如它的值应该是select quan from material where idno='aaaaaaa'
这句是没错的.如果上句中的?????nquan可不可以是一个语句,因为它的数值来源天另一个表,比如它的值应该是select quan from material where idno='aaaaaaa'
...全文
请发表友善的回复…
发表回复
CrazyFor 2003-08-26
- 打赏
- 举报
insert feedinme receipt,goodsid,unit,quantity,storage,comefrom
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
TaoGeGe 2003-08-26
- 打赏
- 举报
值列裡可以有子查詢
haozhiyuan2003 2003-08-26
- 打赏
- 举报
insert feedinme (receipt,goodsid,unit,quantity,storage,comefrom)
Select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno = 'aaaaaaa'
Select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno = 'aaaaaaa'
txlicenhe 2003-08-26
- 打赏
- 举报
insert feedinme (receipt,goodsid,unit,quantity,storage,comefrom)
Select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno = 'aaaaaaa'
Select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno = 'aaaaaaa'
j9988 2003-08-26
- 打赏
- 举报
insert feedinme (receipt,goodsid,unit,quantity,storage,comefrom)
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
j9988 2003-08-26
- 打赏
- 举报
insert feedinme (receipt,goodsid,unit,quantity,storage,comefrom)
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
select 'aaa','bbbb','cccc',456,quan,'eeee' from material where idno='aaaaaaa'
