fangles <[EMAIL PROTECTED]> wrote:
Hello, I am trying to compare a currently opened database table with
a table from an attached database. Both tables have identical
structures but the attached table has an extra record.
The first lists records from the internal table NOT CONTAINED IN the
attached table
The second lists records NOT CONTAINED IN the internal table
Select a.displayas AS displayas FROM addresses a INNER JOIN
RemoteDb.addresses b ON a.displayas <> b.displayas
This query doesn't do what you think it does. Once you get past the
little syntax problem, you'll get displayas from every record in
addresses table, each repeated multiple times.
Make it
select displayas from main.addresses
where displayas not in (select displayas from RemoteDb.addresses)
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
