You'd need to make sure your select captures all of that. Then configure the fields output to format it however you want. Example as follows.
Query:
Code:
SELECT * FROM `#__team` WHERE `name` = '[cb_team]'
Output: Single Row
Columns: Multiple Columns
Display: Custom
Custom:
Code:
<img src="[column_logo]" alt="[column_name]" />
The above is just an example to show how this is done. I've no idea your table structure or your field names so you will need to adjust as necessary. Alternatively you could use the Layouts feature to format the query result, but that could result in broken images being displayed if there is no query result.
krileon
