Hi All

I got 2 table ...
numtot (drawdate datetime,digit4 nchar(4),total Int)
result drawdate datetime,price1 nchar(4),price2 nchar(4),,,con_10 nchar(4)

Is this the only way of selecting the value from numtot againt result
or there is a better way to do it

   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)