> select * from numtot where drawdate = @mdate and > ( <=== YOU WANT THIS ? > digit4 = (select price1 from result where drawdate = @mdate) or > digit4 = (select price2 from result where drawdate = @mdate) or > digit4 = (select price3 from result where drawdate = @mdate) or > digit4 = (select spe_1 from result where drawdate = @mdate) or > digit4 = (select spe_2 from result where drawdate = @mdate) or > digit4 = (select spe_3 from result where drawdate = @mdate) or > digit4 = (select spe_4 from result where drawdate = @mdate) or > digit4 = (select spe_5 from result where drawdate = @mdate) or > digit4 = (select spe_6 from result where drawdate = @mdate) or > digit4 = (select spe_7 from result where drawdate = @mdate) or > digit4 = (select spe_8 from result where drawdate = @mdate) or > digit4 = (select spe_9 from result where drawdate = @mdate) or > digit4 = (select spe_10 from result where drawdate = @mdate)or > digit4 = (select con_1 from result where drawdate = @mdate) or > digit4 = (select con_2 from result where drawdate = @mdate) or > digit4 = (select con_3 from result where drawdate = @mdate) or > digit4 = (select con_4 from result where drawdate = @mdate) or > digit4 = (select con_5 from result where drawdate = @mdate) or > digit4 = (select con_6 from result where drawdate = @mdate) or > digit4 = (select con_7 from result where drawdate = @mdate) or > digit4 = (select con_8 from result where drawdate = @mdate) or > digit4 = (select con_9 from result where drawdate = @mdate) or > digit4 = (select con_10 from result where drawdate = @mdate) >) >>
> select * from numtot ; > JOIN result ON result.drawdate=numtot.drawdate; > WHERE numtot.drawdate = M.mdate ; > AND AT(numtot.digit4+CHR(0),result.price1+CHR(0)+result.price2+CHR(0)+...+CHR(0)+result.con_10+CHR(0))>0 >