>Okay, I will make another column having record Number. Than now how it will be done
>
>>>Suppose I have a table A with 100 records and Table B with 25 Records. I want to insert the records of Table B in Table A, after 75 records of Table A.
>>>
>>>I.e First 75 recodrs shoud be of A , next 25 of B and than 25 of A. How it will be done ?
>>>
>>>.
>>
>>Tables are unordered set. You will need to have some column in your table to control the order, say, date or ID column.
Can you post your both tables structures?
If it's not broken, fix it until it is.
My Blog