im working with sql and crystal report this is my query..
SELECT `tblpr`.`PR_Number`, `tblpr`.`Date_Submitted`, `tblpr`.`Date_Needed`, `tblpr`.`Department`, `tblpr`.`Purpose`, `tblprproducts`.`Product_Name`, `tblprproducts`.`Brand`, `tblprproducts`.`Description`, `tblprproducts`.`Part_Number`, `tblprproducts`.`Quantity`, `tblprproducts`.`Unit_Measurement`, `tblsignatories`.`Signatory1`, `tblsignatories`.`Designation1`, `tblsignatories`.`Signatory2`, `tblsignatories`.`Designation2`, `tblsignatories`.`Signatory3`, `tblsignatories`.`Designation3` FROM (`tblpr` `tblpr` INNER JOIN `tblprproducts` `tblprproducts` ON `tblpr`.`PR_Number`=`tblprproducts`.`PR_Number`) INNER JOIN `tblsignatories` `tblsignatories` ON `tblpr`.`PR_Number`=`tblsignatories`.`PR_Number` where tblpr.pr_number =
this query will return 4 records from the database that's good, but when it is displayed in crystal report 4 records will be displayed 16 records.. each item is repeated 4 times..
what should be the problem?
thanks in advance!