SELECT
	IPIM.purchaseInvoiceId,
	IPM.purchaseId,
	IPM.purchaseDate,
	IPRM.purchaseReturnId,
	IPRM.purchaseReturnDate 
FROM 
	InventoryPurchaseMaster IPM
	INNER JOIN InventoryPurchaseInvoicePurchaseVoucherIds IPIPVID	
		ON	IPM.purchaseId			= IPIPVID.purchaseVoucherId 
	INNER JOIN InventoryPurchaseInvoiceMaster IPIM
		ON	IPIPVID.purchaseInvoiceId 	= IPIM.purchaseInvoiceId 
	INNER JOIN InventoryPurchaseInvoicePurchaseReturnIds IPIPRID
		ON	IPIM.purchaseInvoiceId 		= IPIPRID.purchaseInvoiceId
	LEFT JOIN InventoryPurchaseReturnMaster IPRM
		ON	IPIPRID.purchaseReturnId	= IPRM.purchaseReturnId
WHERE 	
	IPIM.purchaseInvoiceId	= '8'