Re: [libreoffice-users] Re: I have a question

omega
        The
Omega sector
America's Last
Line of
Defense

*That sounds like they will be merged ! . . They are to remain separate 
and the "B" file is to be used for a mailing thing after it has the 
duplicates removed . . the mailing thing I have figured out and what 
fields/columns to use ! !



*

On 07/28/2012 06:38 AM, Andreas Säger wrote:
> Am 28.07.2012 14:17, Lynne Stevens wrote:
> > omega
> >      The
> > Omega sector
> > America's Last
> > Line of
> > Defense
> >
> > *How do I check for duplicates in a data base using another data base ?
> >
> >
> >
> > *
>
> SELECT "A".*
> FROM "A" JOIN "B" ON "A"."ID" = "B"."ID"
>
> returns all rows from table A with an equivalent ID in table B.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted