[求助]access 查询语句

applece

SELECT [05_UEHA_DATA].LOTNO AS Lot_No, [05_UEHA_DATA].WAFER_LOT, [05_UEHA_DATA].MODEL AS jz_name, Mid([MODEL],6,7) AS MOD, [10_PRODUCTION_DATA].[10_DATE] INTO 00_scyd
FROM 05_UEHA_DATA LEFT JOIN 10_PRODUCTION_DATA ON [05_UEHA_DATA].WAFER_LOT = [10_PRODUCTION_DATA].WAFER_LOT
WHERE (((Mid([MODEL],11,2))="A1" Or (Mid([MODEL],11,2))="A2" Or (Mid([MODEL],11,2))="F1"));


请问上面的查询语句有没有语法错误呢？

[此贴子已经被作者于2005-4-23 11:53:59编辑过]

mhaibo

有错误：在where 语句中没有指明是哪个表的字段

sxfwang

既然是Select,为什么还有INTO?