basically what i want to do is search the sales table and the sales detail table together. but when the search results are displayed i only want to show 1 row for each sale. right now i get duplicate info depending on how many products the person bought.
The sales table has OrderID primary key and the customers name, address etc.
the sales_detail table has SaleID as foreign key to primary sales OrderID table.