I have the following problem with I have a database with two tables that

are linked on the issue id (issue, actions) my problem lies that a issue

can have many actions (the unique id is the ID not issue id)



my sql statement



 sql = "SELECT  [Actions].[ID], [Issues].[Date] AS Issues_Date,

[Issues].[Time], [Issues].[Client],



[Issues].[Contact], [Issues].[Component], [Issues].[Type],

[Issues].[Name], [Issues].[Status],



[Issues].[Assigned], [Issues].[Description] AS Issues_Description,

[Issues].[MailNote], [Issues].[qa],



[Issues].[Sent], [Issues].[Priority], [Actions].[Date] AS Actions_Date,

[Actions].[Time] AS



Actions_Time, [Actions].[Description] AS Actions_Description,

[Actions.TakenBy], [Contact].[tel],



[Contact].[Mobile], [Contact].[email], [Contact].[Position],

[Contact].[Address], [Contact].[Country],



[Actions].[Description], [Actions].[ID] FROM (Contact INNER JOIN Issues ON



[Contact].[Contact]=[Issues].[Contact]) INNER JOIN Actions ON

[Issues].[IssueID]=[Actions].[IssueID]"



sql=sql & " WHERE Actions.IssueID=" & which_id 



what i need to do is somehow iterate round for all possible actions on

issue id and push it out to a textbox like



<p><textarea rows="4" name="IssueDescription" cols="54"> <%=form_issuedesc%></textarea></p>

          

I hope someone can help