On 8/11/2013 10:48 PM, ChingChang Hsiao wrote:
I have 2 similar tables. If_idx is the key. 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, 29 and then delete it from the table lldp_stats_tx_port_table_clear.
Is this what you are looking for? delete from lldp_stats_tx_port_table_clear where if_idx not in (select if_idx from lldp_stats_tx_port_table); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users