Problem with join on same table in two different dbs

[rdemyan via AccessMonster.com]

I have two databases, db1 and db2, with the same table, TableA. I want to
select the records from TableA in db1 that have a LAST_UPDATE SomeDate.
Then I want to get the identical records in TableA from db2. However the
LAST_UPDATE dates will be different between db1 and db2. That's the point. If
they are different, then there were changes made to the record in db1. I'm
going to then process this further to find out what the changes were.

But right now I just want to construct an SQL statement that I can use in
code to return the data that I need. Ultimately, I'm going to run this code
on over 100 tables. That's why I need to apply some type of filter (i.e.
LAST_UPDATE SomeDate) in order to have this overall process completed in a
short time.

I guess the statement could just get all records where the LAST_UPDATE is
different between TableA in db1 and TableA in db2. But speed is important,
because ultimately I will apply it to the 100 tables.

Note that db1 is the current database and db2 is an external database.

So, for example, I would have thought the following would work:

------------------------------------------------------------------------------
--

SELECT A.*, B.* FROM [TableA] As A
LEFT JOIN (SELECT * FROM [C:\.....].[TableA]) AS B ON (A.FIELD1 = B.FIELD1)
AND (A.FIELD2= B.FIELD2) AND (A.FIELD3= B.FIELD3)
WHERE A.LAST_UPDATE #SomeDate#

------------------------------------------------------------------------------
--
What's happening right now is that all records from the table are being
returned. In the test case I should have had 1 record returned and instead I
got all of them (1500+)

Thanks.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200612/1

['69 Camaro]

Hi, David.

Doh! Mystery solved. I'm embarrassed because I didn't take a closer look at
all those messages in my Sent folder. There are a bunch of duplicate messages,
all in 2004 and some of 2005. I don't know how they got there, but I know who
the culprit is -- me! The Google count is only a tiny bit lower than it should
be. That I can live with.

Thanks for the suggestions.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAMwrote in
message news:l7******** *************** *******@adelphi a.com...

Hi, David.

>they weren't honoring
No-Archive headers -- they later removed all of those. Have you ever
used that?

No. But here's something I noticed way back when Google Groups first became
"groups-beta.google.com " near the end of 2004. I'd search a topic, such as an
error message, and not get nearly as many hits as I expected. Then I'd do the
same search at groups.google.c a or groups.google.c o.uk, and those searches
revealed 5% to 35% more results, as if they were searching a different
database of posts. Eventually, all the other English-speaking Google domains
switched to the same search methodology as the first groups-beta did and
inherited the new Google Groups interface and what looked like (to me) fewer
posts to search from than they'd had before the changeover.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...

>"'69 Camaro" <Fo************ **************@ Spameater.orgZE RO_SPAM>
wrote in news:Bs******** *************** *******@adelphi a.com:

>>And it's not just my own messages that are missing from searches.
Messages and occasionally whole threads are missing from the
archive. I've looked for message ID's I downloaded from my ISP's
news server, but couldn't find them in Google Groups. I've also
looked for discussion threads that I'd read a few years ago and
wanted to refresh my memory, but they aren't in Google Groups any
more.

There was a time when Google (or Dejanews) restored the archives
from copies they got from all over, and they weren't honoring
No-Archive headers -- they later removed all of those. Have you ever
used that?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/