hello masters
Please chek this statment...

select * from stud_data,old_dont_use where [Sr No]=11 and old_dont_use.[Sr No]=stud_data.[Sr No]

i think it is not valid statment.
there are two tables stud_data and old_dont_use
stud_data is master table and i want data from old.... as per sr no in stud_data

so if it any change in it then please do it
thnk you very muchh in advance