Hi
normally we can use date condition like this SELECT id FROM events WHERE start BETWEEN '2013-06-13' AND '2013-07-22'
but can i use like this
select * from CalendarSchedule where PhysicianID = '2' and start between '2013-06-13'
I am getting syntax error at and;
if i wanna club those 2 queries how could i?
CalendarSchedule --->It has all the lists of Physician ID , physician name , PatientID, start date , enddate ,etc..
there is another table with the name PhysicianMaster (only physicians list is provided)
My task is I need all patient Name and full address that were seen by Dr. Liu (Physician)with in the last year.
And I need this like now.
I have started doing that like
grabbing the physicianID then merged with calendar schedule but from date and start date (from last year august to this year august ) whatever the pati ...
Go to the complete details ...