Problem: HR/MedRecords in disjoint RDBs

Imagine a database table in one company:

FredCo Human resources record

id	name	manager	healthProvider	healthPlanId
1	Pat	2	DRD	s21852779q3
2	Jean	NULL	DRD	s21738239q3

and a database table in a completely separate institution:

DRD (health care provider) record

id	name	primaryPhys	foots-the-bill
s21852779q3	Pat	186	FredCo
s21738239q3	Jean	718	FredCo

Difficult to join with conventional technology