Hello,
I am trying to generate a SQL statement that is causing me some trouble. In fact, i'm not even sure if its possible to accomplish using SQL. Any help would be appreciated, even if you can point me in the direction of what to research.
-Matt
-----------------------------------------------------------
My database 'AUDITS' table looks like the following. Of course, the 'recommendation' field relates to another table.
ID NAME RECOMMENDATION (RECO)
-- ---- --------------
1 John 1
2 John 1
3 John 2
4 Jim 1
5 Jim 1
6 Sue 1
I would like to create a SQL query that returns a recordset as follows, showing the sums of the values from the same table:
NAME NO. OF RECORDS NO. OF (RECO)1 NO. OF (RECO)2
---- -------------- -------------- --------------
Jim 2 2 0
John 3 2 1
Sue 1 1 0
I am trying to generate a SQL statement that is causing me some trouble. In fact, i'm not even sure if its possible to accomplish using SQL. Any help would be appreciated, even if you can point me in the direction of what to research.
-Matt
-----------------------------------------------------------
My database 'AUDITS' table looks like the following. Of course, the 'recommendation' field relates to another table.
ID NAME RECOMMENDATION (RECO)
-- ---- --------------
1 John 1
2 John 1
3 John 2
4 Jim 1
5 Jim 1
6 Sue 1
I would like to create a SQL query that returns a recordset as follows, showing the sums of the values from the same table:
NAME NO. OF RECORDS NO. OF (RECO)1 NO. OF (RECO)2
---- -------------- -------------- --------------
Jim 2 2 0
John 3 2 1
Sue 1 1 0