语句如下： insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) values ('？？','1','0','1','2000','2000','1',getdate())
？？这里我想调用一个语句，直接取users里的name字段等于jack的id数字，该怎么写？SQL code: insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) select id数字,'1','0','1','2000','2000','1',getdate() from users where name字段='jack'
谢谢楼上，可以了，感谢了 LZ好厉害 ndcc5 SQL code: insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) SELECT UID,'1','0','1','2000','2000','1',getdate() from USERS WHERE name='JACK'
