need double join query or not??

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
At the moment i have this query:

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

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

Re: need double join query or not??

On May 2, 11:09 am, wrote:
Quoted text here. Click to load it

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 = 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

online accounting on bash bases
Online Einnahmen-Ausgaben-Rechnung
m2m server software gmbh

Site Timeline