Hello My Sql Statement Repeating Data My Statement is
select WareHouseStock.Product_Name, PS.ProductStock_Id, PS.Product_Id,WareHouseStock.Price, PS.Stock_In_Old, PS.Stock_In_Rejected_Old,
PS.Stock_In_EnteredDatetime, WareHouseStock.Job_Code, WareHouseStock.F_Name, WareHouseStock.L_Name
from (select PSer.Product_Name,PSer.Product_Id, PSer.Price,Job.Job_Code, _USER.F_Name, _USER.L_Name
from tblProductService_Base as PSer
join tblJobParts_Base as JP on JP.Product_Id=PSer.Product_Id
join tblJob_Base as Job on job.Job_Id=jp.Job_Id
join tblUser_Base as _USER on _USER.User_Id=job.User_Id
group By PSer.Product_Name, PSer.PRODUCT_ID, PSer.Price,Job.Job_Code,_USER.F_Name, _USER.L_Name ) WareHouseStock
join tblProductStock_Base as PS on PS.Product_Id=WareHouseStock.Product_Id where PS.Warehouse_Id=153
...
Go to the complete details ...