quote:

---

Originally posted by sixdeep357

Hi. I've only been working with sql for a few weeks now and I'm trying to join multiple tables. I've pasted my query below. It works except for the fact that I get two records (exact same data in each field) for each patient when I run it. I must not have a clear understanding of how the join works. Does anyone happen to know why I get two of each patient record and how I might change the query to return only one entry per patient?
Thanks


SELECT dbo.caseintraop.anes_start_datetime, dbo.caseintraop.anes_stop_datetime, dbo.casemain.casemain_id, dbo.caseintraop.pat_or_in_datetime,
dbo.caseintraop.pat_or_out_datetime, dbo.casereslist.res_id, dbo.casereslist.room_in_datetime, dbo.casereslist.room_out_datetime,
dbo.casereslist.resrole_id, dbo.casemain.pat_displayname, dbo.casemain.pat_mrn, dbo.casemain.pat_acct_num, dbo.anestypelist.anestype_id,
dbo.resrole.name, dbo.casereslist.res_name
FROM dbo.casereslist INNER JOIN
dbo.casemain ON dbo.casereslist.casemain_id = dbo.casemain.casemain_id INNER JOIN
dbo.caseintraop ON dbo.casemain.casemain_id = dbo.caseintraop.casemain_id INNER JOIN
dbo.anestypelist ON dbo.casemain.casemain_id = dbo.anestypelist.casemain_id INNER JOIN
dbo.resrole ON dbo.casereslist.resrole_id = dbo.resrole.resrole_id
WHERE (dbo.resrole.name = 'ANESTHESIOLOGIST') OR
(dbo.resrole.name = 'CERTIFIED REGISTERED NURSE ANESTHETIST')

---