Sql query need

Question

Below is data

CREATE TABLE #ItemMasterFile(CodeItem INT,Descriptionitem VARCHAR(50))    
     
CREATE TABLE #Probale(BID INT,CodeItem INT,prdQTY INT,Entrydate DATETIME)    
 CREATE TABLE #SaleOrder(Orderno INT, Entrydate DATETIME)    
Create Table #OrderDetail(ID int ,Orderno int,CodeItem INT,O_Rate int )     
CREATE TABLE #tbl_BalPacM(PID INT, Orderno int,Entrydate DATETIME)    
CREATE TABLE #tbl_PckDetail(DID INT,PID int,BID int,Codeitem int,Pack_Qty int)    
     
   
     
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 #Probale VALUES(10011,1,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10012,3,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10013,11,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10014,10,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10015,8,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10016,9,1,'01-08-2022')    
INSERT INTO #Probale VALUES(10017,9,1,'01-08-2022')    
     
INSERT INTO #SaleOrder VALUES(111,'01-08-2022')    
INSERT INTO #OrderDetail VALUES(1,111,1,1)    
INSERT INTO #OrderDetail VALUES(2,111,3,12)    
INSERT INTO #OrderDetail VALUES(3,111,11,13)    
INSERT INTO #OrderDetail VALUES(4,111,10,14)    
INSERT INTO #OrderDetail VALUES(5,111,8,14)    
  
  
INSERT INTO #tbl_BalPacM VALUES(1001,111,'01-08-2022')    
  
     
INSERT INTO #tbl_PckDetail VALUES(1,1001,10011,1,1)    
INSERT INTO #tbl_PckDetail VALUES(2,1001,10012,3,1)    
INSERT INTO #tbl_PckDetail VALUES(3,1001,10013,11,1)    
INSERT INTO #tbl_PckDetail VALUES(4,1001,10014,10,1)    
INSERT INTO #tbl_PckDetail VALUES(5,1001,10014,10,1)   
     

Descriptionitem =From #ItemMasterFile
Pack_QTY = From #tbl_PckDetail table
O_Rate = From #OrderDetail

Answer 1

Perhaps something like this.

   SELECT m.Descriptionitem, SUM(pd.Pack_Qty) Pack_Qty, MIN(o.O_Rate) O_Rate  
    FROM @ItemMasterFile m JOIN @tbl_PckDetail pd ON m.CodeItem = pd.Codeitem  
      JOIN @OrderDetail o ON o.CodeItem = pd.Codeitem  
    GROUP BY m.Descriptionitem  

Not really sure where your 10 came from for L though. Based upon your sample data it should be 14. I also, for demo purposes, used table tables so switch the @ back to # for your version if you're using temp tables.