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.
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.