Join on condition

[dr4ke]

I have 4 queries (Active, Deleted, Disabled & Suspended) which show Mailboxes with their respective status's (the status's are worked out from other conditions hence why 4 queries). Within each query there are 5 sizes (100MB, 1GB, 5GB, 50GB, Unlimited). What I would like to do is be able to create a query which counts each status by mailbox size, I.e.:

Mailbox Size	Active	Deleted	Disabled	Suspended
100MB	30	12	13	90
1GB	12	13	51	15
5GB	39	259	21	123
50GB	140	145	112	109
Unlimited	120	150	215	214

It is it possible to InnerJoin queries, while at the same time counting individual query's?

[pbaldy]

I would think you could join on the mailbox size field, unless I'm misunderstanding something.

[dr4ke]

You are, sorry, but it was probably my error in the explanation. There isn't actually a 'Status' field, the status is made from a number of conditions of other columns

[pbaldy]

But aren't the queries creating that field? Can you post the db here?