Hi All,

Im trying to write a sql statement for a search feature which contains 2 relational tables.

Im am getting the right data ok, but getting duplicate records of the main table if 2 or more items in the second table matches

How do i only get it to only output the member once if say 2 of his products match the search phase.

so for example member "tim" has two products product1, product2 and the keyword was product my result would be
tim
tim

how do i get on to be displayed once

Thanks

Tim :)



TDA

__________________
TDA

well it depends on exactly what you want to get in your resultset. If you only want fields from the members table then don't include any from membersproducts in the SELECT and add a GROUP BY for each of the members fields

If you are looking for display of just Membername, you can use DISTINCT Keyword in your select alternatively (if you are not using * or multiple columns there) and exclude the membersproducts.* from there.

_________________________
- Vijay G
Strive for Perfection