select * from numtot where drawdate = @mdate and
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)