Posted on: 6/25/2011 8:20:52 AM | Views : 562

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 ...