Try CStr() function, I am almost sure that this function returns Date in some format as string but not exactly as DTOS()
select * from Visits inner join Doctors where patient_name + CStr(date) in (select patient_name + CStr(date) from ...
I'll keep digging :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.