现在有两个表,我想从AuditList表中取出数据,插入到ViewList表中,请问如何实现!
下面的语句是从AuditList,CategoryList中取出的数据
SELECT auditno, auditname, auditunits, audittypeno, auditcolor, auditsave, auditinprice, auditdate, audittype
FROM AuditList 我想把上面取出的数据,插入到ViewList中,请问如何实现!
ViewList表中已经定义了no, name, units, typeno, color, save, inprice, date, type
下面的语句是从AuditList,CategoryList中取出的数据
SELECT auditno, auditname, auditunits, audittypeno, auditcolor, auditsave, auditinprice, auditdate, audittype
FROM AuditList 我想把上面取出的数据,插入到ViewList中,请问如何实现!
ViewList表中已经定义了no, name, units, typeno, color, save, inprice, date, type
insert into ViewList (no, name, units, typeno, color, save, inprice, date, type)
SELECT auditno, auditname, auditunits, audittypeno, auditcolor, auditsave, auditinprice, auditdate, audittype
FROM AuditList;