matthusby / brewcompetitiononlineentry

Automatically exported from code.google.com/p/brewcompetitiononlineentry
0 stars 0 forks source link

Report request - SQL included #423

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Would like report that lists brewer's name, email, and entry numbers
2.
3.

What is the expected output? What do you see instead?
Email Address, Last Name, First Name, Entries

What version of the product are you using? On what operating system?
1.3.0.4

Please provide any additional information below.

SELECT b.breweremail, cb . *
FROM (

SELECT brewbrewerlastname AS 'Last Name', brewbrewerfirstname AS 'First Name', 
brewbrewerid, GROUP_CONCAT( id
ORDER BY id ) AS 'Entries'
FROM comp_brewing
GROUP BY brewbrewerlastname, brewbrewerfirstname, brewbrewerid
)cb, comp_brewer b
WHERE cb.brewbrewerid = b.id
ORDER BY 'Last Name', 'First Name'

Original issue reported on code.google.com by chad.sh...@gmail.com on 13 Jun 2014 at 6:01