Please provide sample data as DDL and DML as follows. This is a sample you will need to provide your own for the question you are asking. Help us help you
--the following is DDL Data Definition Language
create table #jeevad(Documenttype varchar(50),
Filepath varchar(50),Remarks varchar(50), Filename varchar(50),
DocumentNo int, Hijri nvarchar(50),Gregorian nvarchar(50), issuedate date)
--the following is DML Data Manipulation Language
insert into #jeevad
select 'CR Certificate SAB General Contracting.',
'c:/filename test', NULL, 123, NULL, NULL, NULL union
--etc etc etc
SELECT RM.*
FROM RMmaster RM
LEFT OUTER JOIN (
SELECT DISTINCT ca1.*
FROM Relationship
CROSS APPLY (
VALUES(ID, RM1),(ID,RM2),(ID,RM3)
) AS ca1(ID,RMID)
WHERE RMID <> ''
) AS REL ON REL.RMID = RM.RMID
WHERE REL.RMID IS NULL