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