>Join Issue and IssueType,
>
>SELECT
> i.*,
> it.*
>FROM Issue i
>INNER JOIN IssueType it ON i.IssueTypeID = it.IssueTypeID
>ORDER BY it.IssueTitle
>
><cfoutput query="theQuery" group="IssueTitle">
> #theQuery.IssueTitle#<br />
> <cfoutput>
> #theQuery.Issue#<br />
> </cfoutput>
></cfoutput>
>
>That's the gist of it, change the columns the the ones you want and see what
>happens. :O)
>
>Ade
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
