need double join query or not??

[dikkuuhh@niemaauwe.nl]

At the moment i have this query:

SELECT number, COUNT( * ) as count ' .
FROM visit ' .
RIGHT JOIN visitHit ON ( visitHit.visitI d = 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.li nk)

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

[Martin Mandl - m2m tech support]

Re: need double join query or not??

On May 2, 11:09 am, dikku...@niemaa uwe.nl wrote:

At the moment i have this query:
>
SELECT number, COUNT( * ) as count ' .
FROM visit ' .
RIGHT JOIN visitHit ON ( visitHit.visitI d = 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.li nk)
>
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