I have one existing table values
id date
1 2011-11-20
2 2011-11-21
3 2011-11-22
4 2011-11-23
5 2011-11-24
6 2011-11-25
and i have temporary table values
id date
3 2011-11-15
6 2011-11-16
7 2011-11-17
8 2011-11-18
0 2011-11-19
now i need to load temporaray table to existing table with all values but we have duplicate id numbers so how to insert the values?
id date
1 2011-11-20
2 2011-11-21
3 2011-11-22
4 2011-11-23
5 2011-11-24
6 2011-11-25
and i have temporary table values
id date
3 2011-11-15
6 2011-11-16
7 2011-11-17
8 2011-11-18
0 2011-11-19
now i need to load temporaray table to existing table with all values but we have duplicate id numbers so how to insert the values?
