Re: [sqlite] compare open table and attached database table

2007-02-19 Thread Rich Shepard
On Sun, 18 Feb 2007, fangles wrote: 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:):):) Look at Joe Celko's books on SQL. He tries to be useful for all

Re: [sqlite] compare open table and attached database table

2007-02-18 Thread fangles
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

[sqlite] compare open table and attached database table

2007-02-18 Thread fangles
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. I wanted to do two queries. The first lists records from the internal table NOT CONTAINED IN the attached