Posted by dikkuuhh on 05/02/07 09:09

At the moment i have this query:

SELECT number, COUNT( * ) as count ' .
FROM visit ' .
RIGHT JOIN visitHit ON ( visitHit.visitId = visit.id ) AND ( type
= "link" )
WHERE ( brochureId = 57 )
GROUP BY number
ORDER BY number

I get a list of the numbers of the links a have with the number of
times it's clicked.

Now i don't wanna know this but the URL of the link, that's in another
table (pageElement.link)

Do i need a double join query or not? Can somebody help me out with an
example?

[Back to original message]