1.çææ¥è¯¢è¡¨
select orderedon,NAME,PARTNUM,PARTNUM,DESCRIPTION INTO æ¥è¯¢è¡¨ FROM 表1 where (orderedon>#1996-08-31# ) and (orderedon<#1996-10-01# )
2.å段æ¥è¯¢ï¼å2次è¿è¡ï¼
select orderedon,NAME,PARTNUM,PARTNUM,DESCRIPTION INTO æ¥è¯¢ä¸´æ¶è¡¨ FROM 表1 where (orderedon>#1996-08-31# )
select orderedon,NAME,PARTNUM,PARTNUM,DESCRIPTION INTO æ¥è¯¢è¡¨2 FROM æ¥è¯¢ä¸´æ¶è¡¨ where (orderedon<#1996-10-01# )
温馨提示:答案为网友推荐,仅供参考