[求助]在VB中怎么实现一个表的内连接查询再INTO新表中?
| SELECT B1.FN AS FN1, B1.LGD AS LGD1, B1.LGT AS LGT1, B1.DGD AS DGD1, B1.DGT AS DGT1, B2.FN AS FN2, B2.LGD AS LGD2, B2.LGT AS LGT2, B2.DGD AS DGD2, B2.DGT AS DGT2 INTO JIE02 FROM 320 B1 INNER JOIN 320 B2 ON DGD1=LGD2 AND LGT2>=LGT1+TC SELECT FN1,LGD1,LGT1,DGD1,DGT1, FN2,LGD2,LGT2,DGD2,DGT2 INTO JIE02OVER FROM JIE02 WHERE LGD1=DGD2 B1\B2是320表的不同称呼 我想通过在VB中按一下就实现JIE02\JIE02OVER有数据 谢谢 |
