SELECT NURSE.FNAME, NURSE.LNAME from NURSE WHERE NURSE.ID in (SELECT a.EMP_RECORD_ID, a.HOSPITALID, a.NURSEID, a.BEGDATE, a.ENDDATE, a.HOSPITALROLE FROM EMPLOYMENTDATA a WHERE a.ENDDATE is NULL) EMPLOYMENTDATA EMP_RECORD_ID Integer not null HOSPITALID Integer not null NURSEID Integer not null BEGDATE Varchar(10) not null ENDDATE Varchar(10) HOSPITALROLE Integer not null
NURSE ID Integer not null FNAME Varchar(25) not null LNAME Varchar(25) not null STREETADDRESS Varchar(25) not null CREDENTIALID Integer not null ZIPCODE Integer not null PHONE Varchar(12) not null
EMPLOYMENTDATA EMP_RECORD_ID Integer not null HOSPITALID Integer not null NURSEID Integer not null BEGDATE Varchar(10) not null ENDDATE Varchar(10) HOSPITALROLE Integer not null
Add your query and the involved tables to the discussion.
ReplyDeleteSELECT NURSE.FNAME, NURSE.LNAME
ReplyDeletefrom NURSE
WHERE NURSE.ID in
(SELECT a.EMP_RECORD_ID, a.HOSPITALID, a.NURSEID, a.BEGDATE, a.ENDDATE, a.HOSPITALROLE
FROM EMPLOYMENTDATA a
WHERE a.ENDDATE is NULL)
EMPLOYMENTDATA
EMP_RECORD_ID Integer not null
HOSPITALID Integer not null
NURSEID Integer not null
BEGDATE Varchar(10) not null
ENDDATE Varchar(10)
HOSPITALROLE Integer not null
NURSE
ID Integer not null
FNAME Varchar(25) not null
LNAME Varchar(25) not null
STREETADDRESS Varchar(25) not null
CREDENTIALID Integer not null
ZIPCODE Integer not null
PHONE Varchar(12) not null
EMPLOYMENTDATA
ReplyDeleteEMP_RECORD_ID Integer not null
HOSPITALID Integer not null
NURSEID Integer not null
BEGDATE Varchar(10) not null
ENDDATE Varchar(10)
HOSPITALROLE Integer not null