SELECT dbo.patients.lastname, dbo.patients.firstname, dbo.meetings.begintime, dbo.meetings.endtime, dbo.meetproc.dcode, dbo.meetproc.description, dbo.meetproc.surgeon FROM dbo.patients INNER JOIN dbo.meetings ON dbo.patients.patientid = dbo.meetings.patientid INNER JOIN dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber FOR XML AUTOThanks in advance.