Re: [sqlite] Merging two SQLites + leaving out duplicates?

"Adam DeVita" wrote in message news:804081910903130900r6c615f02u2b72ba810cccf...@mail.gmail.com > Suppose you have a field that time stamps the date each company's data > was entered. > > Unfortunately some records in old2.db have newer contact information, > while others

Re: [sqlite] Merging two SQLites + leaving out duplicates?

Good day, I'd like to tack on an additional question, since it is a common case applied to the goal of this thread. Suppose you have a field that time stamps the date each company's data was entered. Unfortunately some records in old2.db have newer contact information, while others are older

Re: [sqlite] Merging two SQLites + leaving out duplicates?

"Gilles Ganault" wrote in message news:bcqkr45c944gv4g1h9ovpjq1ood1i1v...@4ax.com > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > wrote: > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The

Re: [sqlite] Merging two SQLites + leaving out duplicates?

On Fri, Mar 13, 2009 at 9:14 AM, Gilles Ganault wrote: > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > wrote: > (snip) > > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The tables live in

[sqlite] Merging two SQLites + leaving out duplicates?

Hello I have two SQLites databases that I need to merge. Some companies are found in both, so I'd like to only keep one record when this occurs. What would be the right way to do this? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org