itgle.com
36Youarecreatingareportwizardtocreateamatrixreport.Thequerybuild,youselectthepatient_namecolumnfromthepatienttable;thedoctor_namefromthedoctorstable;andthedoctor_ID,patient_IDandIDcolumnsfromtheproceduretable.Inthereportwizardyouselectpatient_nameastherow
题目
36Youarecreatingareportwizardtocreateamatrixreport.Thequerybuild,youselectthepatient_namecolumnfromthepatienttable;thedoctor_namefromthedoctorstable;andthedoctor_ID,patient_IDandIDcolumnsfromtheproceduretable.Inthereportwizardyouselectpatient_nameastherowvalue,doctor_IDasthecolumnvaluesandthecountasthecellvalues.Youneedtoaddatotalforeachdoctorscolumn.Inthewizardreportwhichtabwillallowyoutocreatethesummarycolumn?（）