471,108 Members | 1,291 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Super-query for a statistics table

Newbie question here, I have a table with 12 employees, their primary key
(an auto-inc int) is the foreign key in numerous other tables, such as
'applications', and 'questions'.
The applications table has a text field, 'status', that can can have values
of 'full', 'quick' or 'pre'.
The questions table also has a text field called 'status' which can have
values of 'new', 'open' or 'closed'.
The problem, I need to display an html table that for each employee shows:
EmpFName EmpLName #ofFullApps #ofQuickApps #ofPreApps #ofNewQues
#ofOpenQues #ClosedQues

Can I do this in one, big bad query? I'd also be happy with running a query
for each employee. Please help so I don't have to run a whole bunch of
queries to do this. Hope that all made sense! TIA.

Jul 19 '05 #1
0 1625

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Kerim Borchaev | last post: by
2 posts views Thread by Clarence Gardner | last post: by
11 posts views Thread by Nicolas Lehuen | last post: by
reply views Thread by Michele Simionato | last post: by
reply views Thread by Delaney, Timothy C (Timothy) | last post: by
6 posts views Thread by Steven Bethard | last post: by
7 posts views Thread by Kent Johnson | last post: by
7 posts views Thread by Pupeno | last post: by
9 posts views Thread by Mike Krell | last post: by
4 posts views Thread by ddtl | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.