Mutliple Count(*) from Different Sources

[Anon]

I am trying to get counts on different tables based on different criteria to be displayed in a single report format. The result could look like as follows:

Name #Visits #Referrals #Failed

A 6 2 1
B 12 4 0

C 9 5 3

I have 3 seperate queries that calculates the 3 columns but how do I get the result in one report.

If anyone has a script or an idea - I will appreciate it.

Thanks!

[Anon]

Probably could be done with LEFT JOINs, but you'll have to supply some more information (like the queries you already have).