Srijon query

SELECT si.InvoiceID, sss.SerialNo
FROM  salesinvoice si
Inner  JOIN InvoiceLineItem AS ili ON si.InvoiceID= ili.InvoiceID
Inner JOIN InvoiceLineItemSerial AS ilis ON si.InvoiceID=ilis.InvoiceID  AND ili.InvoiceLineItemID=ilis.InvoiceLineItemID
Inner JOIN skubatchstockserial AS sss ON sss.SKUSerialID=ilis.SerialID AND sss.SKUBatchID=ilis.SKUBatchID
where  sss.SerialStatus=1