i have three tables i want to do a query against all three to determine how many times the id appears in each table. here's the data structure of the resulting query
cdc id udccount udcstatcnt labtestcnt
356-2343 3 3 2

udccount - ucd.dbf
udcstatcnt - udcstat.dbf
labtestdcnt = labtest.dbf

how can i do this?