Below is data 

CREATE TABLE #ItemMasterFile(CodeItem INT,Descriptionitem VARCHAR(50))  
   
CREATE TABLE #Probale(BID INT,CodeItem INT,prdQTY INT,Entrydate date,Orderno int)  
   
CREATE TABLE #salesorder (Orderno int,Order_Ref_No varchar(50)) 
   
INSERT INTO #ItemMasterFile VALUES(1,'A')  
INSERT INTO #ItemMasterFile VALUES(2,'B')  
INSERT INTO #ItemMasterFile VALUES(3,'C')  
INSERT INTO #ItemMasterFile VALUES(4,'D')  
INSERT INTO #ItemMasterFile VALUES(5,'e')  
INSERT INTO #ItemMasterFile VALUES(6,'f')  
INSERT INTO #ItemMasterFile VALUES(7,'g')  
INSERT INTO #ItemMasterFile VALUES(8,'h')  
INSERT INTO #ItemMasterFile VALUES(9,'K')  
INSERT INTO #ItemMasterFile VALUES(10,'L')  
INSERT INTO #ItemMasterFile VALUES(11,'M')  
 
INSERT INTO #salesorder VALUES(111,'A_1') 
INSERT INTO #salesorder VALUES(222,'A_2')  
INSERT INTO #salesorder VALUES(333,'A_3')  
   
INSERT INTO #Probale VALUES(10011,1,1,'01-06-2019',111)  
INSERT INTO #Probale VALUES(10012,1,1,'02-06-2019',111)  
INSERT INTO #Probale VALUES(10013,11,1,'03-06-2019',222)  
INSERT INTO #Probale VALUES(10014,10,1,'08-06-2019',222)  
INSERT INTO #Probale VALUES(10015,8,1,'03-06-2019',333)  
INSERT INTO #Probale VALUES(10016,9,1,'08-06-2019',333)  
INSERT INTO #Probale VALUES(10017,9,1,'08-06-2019',333)  

Output