Stored Proc Help - Basic

Hi there,

I'm very new to this and I need your advice. I am looking to create a stored procedure, but maybe it's not the best way, maybe there is another way, your advice is appreciated.

I am creating crystal reports for an application and they are displayed through a web portal. The limitation on the print functionality of this portal is that it cannot deal with sub reports. I have been told to create a stored proc and to query it for the results.

The scenario is simple. There are 3 tables namely controls, account_controls and accounts. The objective is to return all accounts linked to one control (each control has one or many accounts)

So i thought, create a stored procedure based on the following query...

SELECT ACCOUNT.DESCRIPTION, CONTROLS.CONTROL_ID, ACCOUNT.TITLE
FROM (ACCOUNT_CONTROL ACCOUNT_CONTROL
INNER JOIN ACCOUNT ACCOUNT
ON (ACCOUNT_CONTROL.ACCOUNT_ID=ACCOUNT.ACCOUNT_ID)
AND (ACCOUNT_CONTROL.LABEL_ID=ACCOUNT.LABEL_ID))
INNER JOIN CONTROLS CONTROLS
ON (ACCOUNT_CONTROL.CONTROL_ID=CONTROLS.CONTROL_ID)
AND (ACCOUNT_CONTROL.LABEL_ID=CONTROLS.LABEL_ID)

This would return something like...

Description ¦ Contol_id ¦ Title
--------------------------------
NULL ¦ id_1 ¦salaries
NULL ¦ id_1 ¦bonuses
NULL ¦ id_1 ¦benifits

So... all i need to do is for each control_id return the accounts, but I need to be able to concatenate them eg.

salaries, bonuses, benifits

Should I populate a temp table for example?

Please advise,

kind regards.