Retrive data from the different database.

[jung1975]

Hello!

I have a three different database that include same data set but in different column name. For example, I have database called "A" that contain doctor's name in doctor's name column and have database called "B" that contain doctor's name in member's column, and also have database "C" that contain doctor's name in medical professional's column. I woluld like to write SQL statement that can compare "A" with "B" and "A" with "C".
For example, If the doctor's name in "A" are also in "B" as a member's name and if it's 80% same(if 8 out of 10 doctor's name in "A" are in "B&quot, then need populate those doctor's name. compare "A" with "C" will use the same way as compare "A" with "B". Any tips will be appreciated it

Thanks
John

 

[WildHare]

John, this is why Codd invented Relational DBs...

Link your other tables in to one of the databases. Use JOINS between DOCTORNAME and MEMBERNAME and MEDICALPROFESSIONAL to see who's where in what table...

There's a FAQ on joins in the Tables & Relationships forum...ahem...



There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm