Vutioulsisoro
New Member
I have these tables Table 1\[code\]tbl1_site[facilityId][name]\[/code\]Table 2\[code\]tbl2_applicant[pvid] [facilityId] [npi] [firstname]\[/code\]FK join key: tbl1_site.facilityId = tbl2_applicant.facilityIdTable 3\[code\]tbl3_abstraction[pvid] [patientnumber][diabetesdiagnosis][dateofbirth]\[/code\]FK join key: tbl2_applicant.pvId = tbl3_abstraction.pvIdi have problem to create a sql query to reproduce this xml output.thanks\[code\]<account> <metadata /> <practice-sites> <practice-site> <metadata> <data-element id="name"> <value>My Own Diabetes Medical Center</value> </data-element> </metadata> <applicants> <metadata /> <applicant> <metadata> <data-element id="npi"> <value>1234567890</value> </data-element> <data-element id="firstname"> <value>Joseph</value> </data-element> </metadata> <clinical-abstractions> <clinical-abstraction> <data-element id="diabetesdiagnosis"> <value>Backward</value> </data-element> <data-element id="dateofbirth"> <value>02/01/2009</value> </data-element> <data-element id="patientnumber"> <value>1</value> </data-element> </clinical-abstraction> </clinical-abstractions> </applicant> </applicants> </practice-site> </practice-sites></account>\[/code\]