saseow
Posts: 744
|
| Posted: 12/19/2008, 7:45 AM |
|
This has to be simple but I can't figure out how to show only unique results.
I have a grid with a product_id. That table has multiple joins so each product is showing up several times. How do I specify that I want the product only to show up once?
|
 |
 |
mentecky
Posts: 321
|
| Posted: 12/19/2008, 12:33 PM |
|
I cheat alot so this may not be the BEST answer but... do your query in Query Builder... Then select SQL in the top left... Add "DISTINCT" after "SELECT" and it should be all good.
Rick
_________________
http://www.ccselite.com |
|
|
|
saseow
Posts: 744
|
| Posted: 12/19/2008, 12:51 PM |
|
Thanks for that. I managed to find out that the grouping will vause a distinct result. Don't ask why 'cause I have no idea.
|
|
|
|
datadoit
|
| Posted: 12/20/2008, 1:00 PM |
|
saseow wrote:
> Thanks for that. I managed to find out that the grouping will vause a distinct
> result. Don't ask why 'cause I have no idea.
> ---------------------------------------
Because GROUPing groups things together. Sorry, I can't think of a
better way to explain that one. :)
|
|
|
|
