how to sync two tables in sqlite.. Production table (instore database):
ID NAME PRICE --------------------------- 1 Item1 110$ 2 Item2 120$ 3 Item3 130$ 4 Item4 140$ 5 Item5 150$ 6 Item6 160$ Synchronize table (data coms from others systems) : ID NAME PRICE --------------------------- 1 Item1 199$ 2 Item2 220$ 7 Item7 170$ In production table i have all items which i sale i my store. in synchorinze table i import new items which not exist in production table but also items which price is changed and alredy exist in production table. I cannot use: insert into production_table select * from sync_table; because only one row will be inserted into production table (item7) but prices for items 1 and 2 dont changed... how can i solve this problem.. thanx a lot
