Igor Tandetnik wrote:
>
> 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
>
>
Thank you Igor, that's fantastic. I'm reading lots of SqLite tutorials but a
lot of the SQL is so far out of my brain's reach that it doesn't make sense
to me. And I love to play:):):)
Have a great day.
--
View this message in context:
http://www.nabble.com/compare-open-table-and-attached-database-table-tf3250700.html#a9037663
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
