# Complex mysql query

**URL:** https://forum.kirupa.com/t/complex-mysql-query/95817
**Category:** Uncategorized
**Created:** [December 1, 2003, 8:02am UTC](https://forum.kirupa.com/t/complex-mysql-query/95817 "2003-12-01T08:02:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![rysolag](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@rysolag](https://forum.kirupa.com/u/rysolag)
#### Post date: [December 1, 2003, 8:02am UTC](https://forum.kirupa.com/t/complex-mysql-query/95817/1 "2003-12-01T08:02:51Z")

</div>

## The Tables

## 1

UserID, UserName

## 2

UserID, Type

(all of the above are int except UserName)  
(Type Ranges from 1-2)

## result

UserName, count(Type==1), count(Type==2)

## ex.

## 1 looks like

1 — testUser

## 2 looks like

1 — 1  
1 — 1  
1 — 2  
1 — 2  
1 — 1

## result should look like

testUser — 3 — 2