SQL命令

基础全面的看：精妙SQL语句收集 http://www.cnblogs.com/mbskys/articles/655003.html

 

关联表的删除命令

DELETE   Cl_quata_detail.*  
  FROM   Cl_quata_detail   INNER   JOIN   tmp   ON   Cl_quata_detail.item_code   =   tmp.item_code;（提示为‘无法从指的数据表中删除')  
   
  delete   Cl_quata_detail  
  FROM   Cl_quata_detail   AS   a,   tmp   AS   b  
  WHERE   a.item_code=b.item_code;(提示为‘指定包含要删除的记录的表’）  
   
  以上两个在ACCESS2000中都无法执行。   
    
解决方法：

  DELETE   FROM   Cl_quata_detail   WHERE   item_code   in  
          (  
          SELECT   Cl_quata_detail.item_code    
          FROM   Cl_quata_detail   INNER   JOIN   tmp    
                  ON   Cl_quata_detail.item_code   =   tmp.item_code  
          )

------

关联表的update命令

            ap.EditBySQL("UPDATE [df_Trade] INNER JOIN [df_Trade_ZZG] ON ([df_Trade].[CustomerID] = [df_Trade_ZZG].[CustomerID] AND [TradeStatus]='收款发货') SET [df_Trade].[Remark] = [df_Trade].[Remark] + '★' + [df_Trade_ZZG].[Remark]")