标题: [求助]access 查询语句 [打印本页] 作者: applece 时间: 2005-4-23 19:53 标题: [求助]access 查询语句 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"));