Posted by Martin Mandl - m2m tech support on 05/02/07 10:38

On May 2, 11:09 am, dikku...@niemaauwe.nl wrote:
> 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?

Is there a real reason you need join already for your first request?

select v.number, count(v.*) as count
from visit v, visitHit, h
where v.brochureid = 57 and h.visitId = v.id and h.type = 'link'
group by v.number
order by v.number

(remark: h.type could also be v.type depends on your data base)

Depending on your database, you might just another table and some more
where statements?

Good luck
Martin

------------------------------------------------
online accounting on bash bases
Online Einnahmen-Ausgaben-Rechnung
http://www.ea-geier.at
------------------------------------------------
m2m server software gmbh
http://www.m2m.at

[Back to original message]