intrivious
07-29-2006, 11:24 AM
here are my tables (simplified):
users:
uID | name
-----------
1 | Chad
2 | Carla
items:
iID | item
-----------
1 | baseball
2 | soccer ball
3 | basketball
purchases:
pID | uID | iID
----------------
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
The question:
How do I make a query resulting in the 'users.name' and 'number of purchases by that user'
By these tables it should look like:
chad | 2
carla | 1
What query can do that for me?
Thanks in advance,
chad
users:
uID | name
-----------
1 | Chad
2 | Carla
items:
iID | item
-----------
1 | baseball
2 | soccer ball
3 | basketball
purchases:
pID | uID | iID
----------------
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
The question:
How do I make a query resulting in the 'users.name' and 'number of purchases by that user'
By these tables it should look like:
chad | 2
carla | 1
What query can do that for me?
Thanks in advance,
chad