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

[rdemyan via AccessMonster.com]

We can agree to disagree. If I ask a question like how to move an exterior
application on the screen and Lyle decides to post a plethora of code in a
public forum with no expectation for recompense, that is his problem. He
should not pout about it afterwards; he shouldn't have posted it in the first
place. I'm not using it anyway. I can honestly say that with the exception
of what I thought was a clever way to refer to tables in another DB (as
opposed to using IN), I doubt I have used much of anything that Lyle has
posted. Who here can say they have never learned anything from anyone else
and all code is original without ever relying on help. The premise that this
is not the case is absurd. This is an educational forum, is it not? If a
responder is really concerned about their "propreitar y code", THEN DON'T POST
IT!

>I have no objection to anyone posting via "AccessMonster, " but am unfamiliar
with the advantages, if any, of doing so instead of reading/posting to the
newsgroup directly. I do know that some believe they profit from the pro
bono work of others.

Larry Linson

I have no idea what your above statement means as I know of no other way to
get at this forum than through AccessMonster. If I should not be using this,
than please direct me to the correct newsgroup. I don't understand why
someone would be offended if I post in AccessMonster. And if there's good
reason to be offended, how would I know that?? I have always tried in the
past to follow forum convention as I realize that responders here are under
no obligation to prrovide help; indeed they're sharing their knowledge with
those of us who, typically, have chosen non-software programming career paths.
I have always been grateful for the help I have received as virtually every
post attests to. However, that is no excuse to abuse and badger those of us
with less experience.
On the surface this objecton over posting in AccessMonster is ludricous. If
no one should be posting here, then shut it down, and let us know where to
post.

You and I both know that Lyle, while no doubt an experience software
programmer, is an abusive and condescending individual. Because he may be an
expert does not IMHO mean that I have to take that abuse.
Thanks.

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

[Larry Linson]

comp.databases. ms-access is a USENET newsgroup, is carried by a great many
news servers, and is readable via a great many news readers. I get it on
the news server provided by my ISP, and read (mostly) with Outlook Express.
It's also archived on, and current messages accessible via,
http://groups.google.com. There are also online newservers, too, but I
don't use any of them, so you'd have to search for them.

I thought I was clear, but, if you didn't understand -- I said I don't have
any problem with posting via AccessMonster, so you are wasting your effort
by responding as though I did. But even those who object haven't the
authority to shut it down, as you (facetiously?) suggest.

Don't be silly -- Lyle doesn't post code and then expect to be paid for it.
He just objects to someone else making a profit off what many of us do for
free, in a free and public newsgroup.

If you don't like Lyle's attitude... respond to him about it (privately or
publicly), ignore it, or complain to his news server (usually there's a
Complain-To line in the headers). If you were reading via a news reader, you
could "plonk", "killfile", or "twitfilter " him so as not to see his posts.
Using the newsgroup indirectly, as you are, I don't know how you'd do
that -- maybe ask at AccessMonster?

But whining here about not posting here isn't going to gain you anything:
and, presuming you do*, on occasion, get some useful answers from someone,
it would cost you those if you carried through.

* and, as you've continued to post questions, I would
guess that you do, or you wouldn't waste your time
and energy

Larry Linson

"rdemyan via AccessMonster.c om" <u6836@uwewro te in message
news:6b5a7be0dd 642@uwe...

We can agree to disagree. If I ask a question like how to move an
exterior
application on the screen and Lyle decides to post a plethora of code in a
public forum with no expectation for recompense, that is his problem. He
should not pout about it afterwards; he shouldn't have posted it in the
first
place. I'm not using it anyway. I can honestly say that with the
exception
of what I thought was a clever way to refer to tables in another DB (as
opposed to using IN), I doubt I have used much of anything that Lyle has
posted. Who here can say they have never learned anything from anyone
else
and all code is original without ever relying on help. The premise that
this
is not the case is absurd. This is an educational forum, is it not? If a
responder is really concerned about their "propreitar y code", THEN DON'T
POST
IT!

>>I have no objection to anyone posting via "AccessMonster, " but am
unfamiliar
with the advantages, if any, of doing so instead of reading/posting to the
newsgroup directly. I do know that some believe they profit from the pro
bono work of others.

Larry Linson

I have no idea what your above statement means as I know of no other way
to
get at this forum than through AccessMonster. If I should not be using
this,
than please direct me to the correct newsgroup. I don't understand why
someone would be offended if I post in AccessMonster. And if there's good
reason to be offended, how would I know that?? I have always tried in the
past to follow forum convention as I realize that responders here are
under
no obligation to prrovide help; indeed they're sharing their knowledge
with
those of us who, typically, have chosen non-software programming career
paths.
I have always been grateful for the help I have received as virtually
every
post attests to. However, that is no excuse to abuse and badger those of
us
with less experience.
On the surface this objecton over posting in AccessMonster is ludricous.
If
no one should be posting here, then shut it down, and let us know where to
post.

You and I both know that Lyle, while no doubt an experience software
programmer, is an abusive and condescending individual. Because he may be
an
expert does not IMHO mean that I have to take that abuse.
Thanks.

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

[rdemyan via AccessMonster.com]

>Don't be silly -- Lyle doesn't post code and then expect to be paid for it.

>He just objects to someone else making a profit off what many of us do for
free, in a free and public newsgroup.

You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts. Does someone have a gun pointed at his head? What world do you live
in??

And that'll be my last post. From other similar discussions I've seen you
get involved in, I know you have to have the last post, so I relinquish.

--
Message posted via http://www.accessmonster.com

['69 Camaro]

You are the one being silly. The simple answer is he shouldn't post the

code if he objects to someone potentially making a profit off of what he
posts.

You _completely_ misunderstand. Look at the Web page you're posting from. See
those ads? Ads by Goooogle. AccessMonster.c om gets revenues from those ads.
Profit. Lyle and all the experts in the newsgroups do all the work providing
answers for folks like you who flock to AccessMonster.c om and occasionally click
on those ads. AccessMonster.c om doesn't share _any_ of those revenues with the
folks who make it possible: Lyle and the thousands of others like him.

Some find AccessMonster.c om's owners' actions unfair or even objectionable, even
if you don't.

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.
"rdemyan via AccessMonster.c om" <u6836@uwewro te in message
news:6b5b4a31a6 9d7@uwe...

Don't be silly -- Lyle doesn't post code and then expect to be paid for it.
He just objects to someone else making a profit off what many of us do for
free, in a free and public newsgroup.

You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts. Does someone have a gun pointed at his head? What world do you live
in??

And that'll be my last post. From other similar discussions I've seen you
get involved in, I know you have to have the last post, so I relinquish.

--
Message posted via http://www.accessmonster.com

[rdemyan via AccessMonster.com]

Oh!

I didn't realize that, how could I? I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

Well, this is news to me. I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation. Perhaps if I had
gotten that the first time. I'm sure I'm not the only one who isn't aware of
this.

So my apologies to Larry, but not to Lyle as he has continually mocked me in
this forum. Frankly, I'm glad he has plonked me.

Thanks.
'69 Camaro wrote:

>You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts.

You _completely_ misunderstand. Look at the Web page you're posting from. See
those ads? Ads by Goooogle. AccessMonster.c om gets revenues from those ads.
Profit. Lyle and all the experts in the newsgroups do all the work providing
answers for folks like you who flock to AccessMonster.c om and occasionally click
on those ads. AccessMonster.c om doesn't share _any_ of those revenues with the
folks who make it possible: Lyle and the thousands of others like him.

Some find AccessMonster.c om's owners' actions unfair or even objectionable, even
if you don't.

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.

>Don't be silly -- Lyle doesn't post code and then expect to be paid for it.
He just objects to someone else making a profit off what many of us do for

[quoted text clipped - 7 lines]

>And that'll be my last post. From other similar discussions I've seen you
get involved in, I know you have to have the last post, so I relinquish.

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

['69 Camaro]

Hi.

I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

And that's why Larry tried so hard to explain it's AccessMonster.c om that Lyle
takes umbrage with, not that you're profiting from the code he provides freely.

I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation.

AccessMonster.c om appears to have gone to great lengths to avoid the mention of
UseNet or newsgroups on their Web site, other than "This website includes both
content owned or controlled by Advenet as well as content owned or controlled by
third parties" in the fine print at the bottom of the page. Unless one
recognizes the names of the "forums" as matching many existing Access newsgroup
names, the fact that these posts are public UseNet articles distributed
worldwide on public news servers is well disguised. It appears that
AccessMonster.c om is providing the experts for each member's own personal tech
support, free of charge. AccessMonster.c om has merely put a Web interface on a
service that expert volunteers provide free to the public, and AccessMonster.c om
is pocketing the advertising money this "free expert tech support" traffic
attracts.

So my apologies to Larry, but not to Lyle as he has continually mocked me in
this forum.

Lyle speaks his mind, very honestly. Some posters come to the newsgroups with
their task clearly defined in their minds, "the what," and they ask for the
steps to complete "the how." The inexperienced ones often choose destinations
that are loaded with mines and when warned about the minefield ahead, they
choose one of two paths. The ones who follow the first path take pause when
warned of the danger, then follow the advice given. The ones who follow the
second path yell, "Damn the torpedoes! Full speed ahead!"

Although you don't want to hear what's been said, if you re-read the threads
you've posted for the past two weeks, you may well see which path you're on and
why Lyle wrote what he wrote. And if you re-read these threads in two years,
don't be surprised at your own reaction.

Frankly, I'm glad he has plonked me.

You may not like his demeanor at times, but Lyle is very, very generous with his
considerable knowledge and expertise. This is not an event to celebrate.

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.
"rdemyan via AccessMonster.c om" <u6836@uwewro te in message
news:6b5bf5ce65 0be@uwe...

Oh!

I didn't realize that, how could I? I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

Well, this is news to me. I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation. Perhaps if I had
gotten that the first time. I'm sure I'm not the only one who isn't aware of
this.

So my apologies to Larry, but not to Lyle as he has continually mocked me in
this forum. Frankly, I'm glad he has plonked me.

Thanks.
'69 Camaro wrote:

>>You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts.

You _completely_ misunderstand. Look at the Web page you're posting from.
See
those ads? Ads by Goooogle. AccessMonster.c om gets revenues from those ads.
Profit. Lyle and all the experts in the newsgroups do all the work providing
answers for folks like you who flock to AccessMonster.c om and occasionally
click
on those ads. AccessMonster.c om doesn't share _any_ of those revenues with
the
folks who make it possible: Lyle and the thousands of others like him.

Some find AccessMonster.c om's owners' actions unfair or even objectionable,
even
if you don't.

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.

>>Don't be silly -- Lyle doesn't post code and then expect to be paid for it.
He just objects to someone else making a profit off what many of us do for

[quoted text clipped - 7 lines]

>>And that'll be my last post. From other similar discussions I've seen you
get involved in, I know you have to have the last post, so I relinquish.

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

[rdemyan]

I've switched over and am now poting in the Usenet group.

'69 Camaro wrote:

Hi.

I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

And that's why Larry tried so hard to explain it's AccessMonster.c om that Lyle
takes umbrage with, not that you're profiting from the code he provides freely.

I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation.

AccessMonster.c om appears to have gone to great lengths to avoid the mention of
UseNet or newsgroups on their Web site, other than "This website includes both
content owned or controlled by Advenet as well as content owned or controlled by
third parties" in the fine print at the bottom of the page. Unless one
recognizes the names of the "forums" as matching many existing Access newsgroup
names, the fact that these posts are public UseNet articles distributed
worldwide on public news servers is well disguised. It appears that
AccessMonster.c om is providing the experts for each member's own personal tech
support, free of charge. AccessMonster.c om has merely put a Web interface on a
service that expert volunteers provide free to the public, and AccessMonster.c om
is pocketing the advertising money this "free expert tech support" traffic
attracts.

So my apologies to Larry, but not to Lyle as he has continually mocked me in
this forum.

Lyle speaks his mind, very honestly. Some posters come to the newsgroups with
their task clearly defined in their minds, "the what," and they ask for the
steps to complete "the how." The inexperienced ones often choose destinations
that are loaded with mines and when warned about the minefield ahead, they
choose one of two paths. The ones who follow the first path take pause when
warned of the danger, then follow the advice given. The ones who follow the
second path yell, "Damn the torpedoes! Full speed ahead!"

Although you don't want to hear what's been said, if you re-read the threads
you've posted for the past two weeks, you may well see which path you're on and
why Lyle wrote what he wrote. And if you re-read these threads in two years,
don't be surprised at your own reaction.

Frankly, I'm glad he has plonked me.

You may not like his demeanor at times, but Lyle is very, very generous with his
considerable knowledge and expertise. This is not an event to celebrate.

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.
"rdemyan via AccessMonster.c om" <u6836@uwewro te in message
news:6b5bf5ce65 0be@uwe...

Oh!

I didn't realize that, how could I? I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

Well, this is news to me. I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation. Perhaps if I had
gotten that the first time. I'm sure I'm not the only one who isn't aware of
this.

So my apologies to Larry, but not to Lyle as he has continually mocked me in
this forum. Frankly, I'm glad he has plonked me.

Thanks.
'69 Camaro wrote:

>You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts.

You _completely_ misunderstand. Look at the Web page you're posting from.
See
those ads? Ads by Goooogle. AccessMonster.c om gets revenues from those ads.
Profit. Lyle and all the experts in the newsgroups do all the work providing
answers for folks like you who flock to AccessMonster.c om and occasionally
click
on those ads. AccessMonster.c om doesn't share _any_ of those revenues with
the
folks who make it possible: Lyle and the thousands of others like him.

Some find AccessMonster.c om's owners' actions unfair or even objectionable,
even
if you don't.

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.

Don't be silly -- Lyle doesn't post code and then expect to be paid for it.
He just objects to someone else making a profit off what many of us do for
[quoted text clipped - 7 lines]
And that'll be my last post. From other similar discussions I've seen you
get involved in, I know you have to have the last post, so I relinquish.

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

[Larry Linson]

"rdemyan" wrote

I've switched over and am now posting in the Usenet group.

Glad to have you here (though I don't have the strong feelings about
AccessMonster that some do; but I don't know the advantage of using it
instead of directly accessing the group).

Now, let me add to what Gunny has said. Sometimes the best advice we can
give is "don't do it the way you have planned", because we see a simpler way
which we recommend. Sometimes when we do that, we don't have, or take, the
time to explain in detail why the way we are recommending against is bad,
and why the way we are recommending is better.

And, sometimes, some of us who answer can be "sharp" or "short" or "abrupt"
(or worse) in our replies, but that doesn't necessarily indicate that the
suggested approach is bad. So, sometimes it's worth looking past a
condescension or a perceived insult -- the logic, design, or technical
solution may be the best solution to the problem at hand.

Best of luck with your projects. Keep asking and try not to be touchy about
the tone in which the answers are presented -- that might cause you to
reject the best choice.

Larry Linson

['69 Camaro]

Hi.

I've switched over and am now poting in the Usenet group.

From Google Groups? Don't they show ads and "sponsored links" with posts, too?
<g, d, & r>

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.
"rdemyan" <rd*****@hotmai l.comwrote in message
news:11******** **************@ h40g2000cwb.goo glegroups.com.. .

I've switched over and am now poting in the Usenet group.

'69 Camaro wrote:

>Hi.

I've mentioned several times that I'm a
consultant in this forum and by profit I naturally thought he meant.....

And that's why Larry tried so hard to explain it's AccessMonster.c om that
Lyle
takes umbrage with, not that you're profiting from the code he provides
freely.

I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation.

AccessMonster. com appears to have gone to great lengths to avoid the mention
of
UseNet or newsgroups on their Web site, other than "This website includes
both
content owned or controlled by Advenet as well as content owned or controlled
by
third parties" in the fine print at the bottom of the page. Unless one
recognizes the names of the "forums" as matching many existing Access
newsgroup
names, the fact that these posts are public UseNet articles distributed
worldwide on public news servers is well disguised. It appears that
AccessMonster. com is providing the experts for each member's own personal
tech
support, free of charge. AccessMonster.c om has merely put a Web interface on
a
service that expert volunteers provide free to the public, and
AccessMonster. com
is pocketing the advertising money this "free expert tech support" traffic
attracts.

So my apologies to Larry, but not to Lyle as he has continually mocked me
in
this forum.

Lyle speaks his mind, very honestly. Some posters come to the newsgroups
with
their task clearly defined in their minds, "the what," and they ask for the
steps to complete "the how." The inexperienced ones often choose
destinations
that are loaded with mines and when warned about the minefield ahead, they
choose one of two paths. The ones who follow the first path take pause when
warned of the danger, then follow the advice given. The ones who follow the
second path yell, "Damn the torpedoes! Full speed ahead!"

Although you don't want to hear what's been said, if you re-read the threads
you've posted for the past two weeks, you may well see which path you're on
and
why Lyle wrote what he wrote. And if you re-read these threads in two years,
don't be surprised at your own reaction.

Frankly, I'm glad he has plonked me.

You may not like his demeanor at times, but Lyle is very, very generous with
his
considerable knowledge and expertise. This is not an event to celebrate.

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.
"rdemyan via AccessMonster.c om" <u6836@uwewro te in message
news:6b5bf5ce6 50be@uwe...

Oh!

I didn't realize that, how could I? I've mentioned several times that I'm
a
consultant in this forum and by profit I naturally thought he meant.....

Well, this is news to me. I'm not sure how I'm supposed to have known this
without someone like you providing a clear explanation. Perhaps if I had
gotten that the first time. I'm sure I'm not the only one who isn't aware
of
this.

So my apologies to Larry, but not to Lyle as he has continually mocked me
in
this forum. Frankly, I'm glad he has plonked me.

Thanks.
'69 Camaro wrote:
You are the one being silly. The simple answer is he shouldn't post the
code if he objects to someone potentially making a profit off of what he
posts.

You _completely_ misunderstand. Look at the Web page you're posting from.
See
those ads? Ads by Goooogle. AccessMonster.c om gets revenues from those
ads.
Profit. Lyle and all the experts in the newsgroups do all the work
providing
answers for folks like you who flock to AccessMonster.c om and occasionally
click
on those ads. AccessMonster.c om doesn't share _any_ of those revenues with
the
folks who make it possible: Lyle and the thousands of others like him.

Some find AccessMonster.c om's owners' actions unfair or even objectionable,
even
if you don't.

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.

Don't be silly -- Lyle doesn't post code and then expect to be paid for
it.
He just objects to someone else making a profit off what many of us do
for
[quoted text clipped - 7 lines]
And that'll be my last post. From other similar discussions I've seen
you
get involved in, I know you have to have the last post, so I relinquish.

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

[David W. Fenton]

"rdemyan via AccessMonster.c om" <u6836@uwewro te in
news:6b5397babd a80@uwe:

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#

Why are you using a subselect?

Why not just:

SELECT A.*, B.*
FROM TableA AS A INNER JOIN TableB AS B ON A.Field3 = B.Field3
WHERE A.Last_Update < B.Last_Update

This ought to get you the matching records (assuming Field3 is the
PK) where TableB has been updated after TableA.

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