DISTINCT

SELECT DISTINCT dbo.Patient.PatientID,

dbo.Patient.PatientHistoryNumber,

dbo.Patient.PatientName,

dbo.Patient.PatientBirthDate,

dbo.Patient.PatientSexRef,

dbo.Patient.PatientAddress,

dbo.Patient.PatientCreationDate,

dbo.Booking.BookingStatusRef,

dbo.Booking.BookingCreationUserRef,

dbo.Booking.BookingPriceDate,

dbo.Booking.BookingPaymentValue,

dbo.Booking.BookingDate,

dbo.Booking.BookingExternalID2,

dbo.Service.ServiceCode,

dbo.Service.ServiceNameLanguage1,

dbo.Schedule.ScheduleStartTime,

dbo.Schedule.ScheduleEndTime,

dbo.Venue.VenueName

 

FROM

dbo.Patient

INNER JOIN dbo.Booking ON dbo.Booking.PatientRef = dbo.Patient.PatientID

INNER JOIN dbo.Service ON dbo.Booking.ServiceRef = dbo.Service.ServiceID

INNER JOIN dbo.Schedule ON dbo.Booking.ScheduleRef = dbo.Schedule.ScheduleID

INNER JOIN dbo.ScheduleVenue ON dbo.Booking.ScheduleRef = dbo.ScheduleVenue.ScheduleRef

INNER JOIN dbo.Venue ON dbo.ScheduleVenue.VenueRef = dbo.Venue.VenueID

WHERE

BookingDate BETWEEN '2011-01-28' AND '2011-01-29' AND ServiceCode != '-1'

ORDER BY BookingDate