Ms Access Join表在单独的数据库中

Ms Access Join表在单独的数据库中

请执行以下 *** 作：

SELECt dr.* INTO AUDIT_TABLEFROM Daily_Report AS drLEFT JOIN [;database=C:QA_Daily_YTD_Report_Export.accdb].[YTD-Daily_Report] AS ytd   ON dr.RecordName = ytd.RecordNameWHERe ytd.RecordName Is Null