主题:sql 紧急求助
请教高手:
有两个表,zb和fb,zb有几千条记录,fb只有一条记录,两个表的记录都为数字,
现在有下面30个条件,目的是把满足其中4个条件的记录从zb中筛选显示出来,等号
前面是zb算式.我编了一个笨程序,四个一组全部排出来,大小有47kb,太麻烦了,
想求一个简单的方法,请各位大虾帮帮忙.
a-b-c=(select a-b-c from fb)
b-a-c=(select b-a-c from fb)
c-a-b=(select c-a-b from fb)
a-b-d=(select a-b-d from fb)
b-a-d=(select b-a-d from fb)
d-a-b=(select d-a-b from fb)
a-b-e=(select a-b-e from fb)
b-a-e=(select b-a-e from fb)
e-a-b=(select e-a-b from fb)
a-c-d=(select a-c-d from fb)
c-a-d=(select c-a-d from fb)
d-a-c=(select d-a-c from fb)
a-c-e=(select a-c-e from fb)
c-a-e=(select c-a-e from fb)
e-a-c=(select e-a-c from fb)
a-d-e=(select a-d-e from fb)
d-a-e=(select d-a-e from fb)
e-a-d=(select e-a-d from fb)
b-c-d=(select b-c-d from fb)
c-b-d=(select c-b-d from fb)
d-b-c=(select d-b-c from fb)
b-c-e=(select b-c-e from fb)
c-b-e=(select c-b-e from fb)
e-b-c=(select e-b-c from fb)
b-d-e=(select b-d-e from fb)
d-b-e=(select d-b-e from fb)
e-b-d=(select e-b-d from fb)
c-d-e=(select c-d-e from fb)
d-c-e=(select d-c-e from fb)
e-c-d=(select e-c-d from fb)
两个表都是5个字段,记录全是数字.比如
zb中a=100,b=20,c=30,d=50,e=200,
fb中a=300,b=100,c=150,d=60,e=330,
zb中a-b-c=50=b表a-b-c,这样就满足第一个条件,zb中e-c-d=120=fb中e-c-d,这样就满足最后一个条件,把同时满足这样4个条件的
记录从zb中显示出来.
有两个表,zb和fb,zb有几千条记录,fb只有一条记录,两个表的记录都为数字,
现在有下面30个条件,目的是把满足其中4个条件的记录从zb中筛选显示出来,等号
前面是zb算式.我编了一个笨程序,四个一组全部排出来,大小有47kb,太麻烦了,
想求一个简单的方法,请各位大虾帮帮忙.
a-b-c=(select a-b-c from fb)
b-a-c=(select b-a-c from fb)
c-a-b=(select c-a-b from fb)
a-b-d=(select a-b-d from fb)
b-a-d=(select b-a-d from fb)
d-a-b=(select d-a-b from fb)
a-b-e=(select a-b-e from fb)
b-a-e=(select b-a-e from fb)
e-a-b=(select e-a-b from fb)
a-c-d=(select a-c-d from fb)
c-a-d=(select c-a-d from fb)
d-a-c=(select d-a-c from fb)
a-c-e=(select a-c-e from fb)
c-a-e=(select c-a-e from fb)
e-a-c=(select e-a-c from fb)
a-d-e=(select a-d-e from fb)
d-a-e=(select d-a-e from fb)
e-a-d=(select e-a-d from fb)
b-c-d=(select b-c-d from fb)
c-b-d=(select c-b-d from fb)
d-b-c=(select d-b-c from fb)
b-c-e=(select b-c-e from fb)
c-b-e=(select c-b-e from fb)
e-b-c=(select e-b-c from fb)
b-d-e=(select b-d-e from fb)
d-b-e=(select d-b-e from fb)
e-b-d=(select e-b-d from fb)
c-d-e=(select c-d-e from fb)
d-c-e=(select d-c-e from fb)
e-c-d=(select e-c-d from fb)
两个表都是5个字段,记录全是数字.比如
zb中a=100,b=20,c=30,d=50,e=200,
fb中a=300,b=100,c=150,d=60,e=330,
zb中a-b-c=50=b表a-b-c,这样就满足第一个条件,zb中e-c-d=120=fb中e-c-d,这样就满足最后一个条件,把同时满足这样4个条件的
记录从zb中显示出来.