回复 25楼 yd1954
就是2楼的算法,要求z59~~z69同时满足条件。
大概意思是:
USE 表8 IN 0
USE 表9 IN 0
GO BOTTOM IN 表8
SELECT h1,h2,h3,z59,z60,z61,z62,z63,z64,z65,z66,z67,z68,z69;
FROM 表9 ;
WHERE ;
!INLIST(z59,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z60,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z61,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z62,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z63,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z64,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z65,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z66,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z67,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z68,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69) and ;
!INLIST(z69,表8.z59,表8.z60,表8.z61,表8.z62,表8.z63,表8.z64,表8.z65,表8.z66,表8.z67,表8.z68,表8.z69)
[此贴子已经被作者于2020-4-14 18:53编辑过]