Count() on two tables.

admin

Administrator
Staff member
Hi,

I have two tables:
- TBPersons -
*Id_Person
*Name
*Age

- TBItems -
*Id_Item
*Id-Person
*Price

Each Person has many items.

I want to perform a SELECT statement that retrieves the NAME, AGE and the total of items for each person.

I've tried to use Count() but I keep getting a syntax error...

Could someone please help me?!

Many thanks,

Jo.
 
Back
Top