Re: [sqlite] delete the extra row from 2 similar tables with 2 key

On 9/28/2013 7:12 PM, ChingChang Hsiao wrote: I have 2 similar tables. If_idx and dest_addr_idx are the keys. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 69 and dest_addr_idx ,1 and then

[sqlite] delete the extra row from 2 similar tables with 2 key

I have 2 similar tables. If_idx and dest_addr_idx are the keys. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 69 and dest_addr_idx ,1 and then delete it from the table