column reference "dateofbirth" is ambiguous LINE 4: DateOfBirth, animaltype.AnimalType AS theType, ^

No data to show on the report.