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

omega
        The
Omega sector
America's Last
Line of
Defense

*There are 2 FILES / Data bases each one has the same number of columns 
126 each has same information except in Column R which has a single 
letter denoting its status as to what kind of sale it is . . Like bank 
sale, for sale by owner, and for sale by a realestate place and so on !
*

*That seems strange as if you wanted information you would have to 
delete the duplicates
in any data base or it would grow by gobs . . I remember in WAY BACK 
time in Super Calc there was a way of doing it  and it is not open to 
Libre-office Calc ? . . haha that was on a big 3.5 inch disk the entire 
program hahahaha went into windows 3.1 . . 500 years ago . .


*

On 07/28/2012 09:39 AM, Alexander Thurgood wrote:
> Le 28/07/12 14:17, Lynne Stevens a écrit :
>
> Hi Lynne,
>
>
> > *How do I check for duplicates in a data base using another data base ?
> By "another data base", do you mean :
>
> (a) another ODB file ?
>
> (b) another type of database manager, e.g. Access vs Calc, or MySQL vs
> Access, or even Access vs Access ?
>
> (c) another table in the same ODB file or in the same database schema
> managed by a unique database manager ?
>
> (d) any or all of the above combined ?
>
> As you can see, the possibilities belie what would appear to be a
> seemingly simple question.
>
>
> Andreas has answered (c) for you, i.e. where both tables are in the same
> database schema.
>
>
> There is no simple way to compare the contents of 2 HSQLDB/ODB files,
> other than extracting the contents from one and importing it into the
> other as a temporary or new table and then comparing the table results
> from within the single ODB file using a JOIN query.
>
> As for (b) LO Base does not allow you to adress two separate database
> schema as far as I know from within a single query. I heard tell once
> that it might be possible with Access tables being read by LO if an ODBC
> connection was being used, and this only would work on Windows. Not
> having tried it, I can't say whether it is true or not.
>
>
> If what you are aiming for is indeed cross-schema queries in order to be
> able to compare, this has been a requested (and never implemented)
> feature in OpenOffice.org for many years.
>
>
>
> Alex


--
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