Hi Fraggle,

SELECT *, COUNT(partner.productid) AS partneraantal

FROM product LEFT JOIN partner ON product.id = partner.productid Inner join (SELECT shop.shopshopnaam, max(shop.shopcpc) as MaxClickPrice FROM shop

GROUP BY shop.shopshopnaam) as Tmp on...

Fraggle (2/7/2009)

---

So really we are looking at

Product 1 Shop b ...

Fraggle (2/7/2009)

---

Alright, I do not have a complete understanding, but I am getting there.

you want to return a result set of

product 1 ...

Fraggle (2/7/2009)

---

From what I understand, you are actually wanting to sort, not by shop, but by Partneraantal. Is this correct? If so, then the issues is the ORDER...

Fraggle (2/7/2009)

---

When you say that the ORDER BY statement doesn't work, are you stating that it is throwing up an error and that you are not able to execute the...