|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
sql problem in Access
I've spent already three hours on this problem and didn't get any progress yet.
Because I am only a rookie, I guess most people here know a solution. The problem is as follows: There are two tables both having instances that reference to the person table by referring to the primary key personID. Now I wants to count the number of references to each person. From one single table is no problem: SELECT [Person].[personSurname], COUNT(*) FROM Person, Table1 WHERE [Person].[personID]=[Table1].[table1PlayerID] GROUP BY [Person].[personSurname]; But how do I get it work for two tables? I tried this: (SELECT [Person].[personSurname], COUNT(*) FROM Person, Table1 WHERE [Person].[personID]=[Table1].[table1PlayerID] GROUP BY [Person].[personSurname]) UNION ( SELECT [Person].[personSurname], COUNT(*) FROM Person, Table2 WHERE [Person].[personID]=[Table2].[table2PlayerID] GROUP BY [Person].[personSurname]); But then I get for each person the number of references from both tables. What I need is an additional ´Group By´ at the end of the query, but how can I implement this? Thanks in advance! |
|
#2
|
|||
|
|||
|
The easiest way is to write a simple union query. Then write another query based on the union query with the grouping.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > sql problem in Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|