4 : select gl.locationid, CONCAT(l.locationname, ", ", l.locationcity) as glocation from tbltournamentgamelocations gl
5 : inner join tbltournamentlocations l on l.locationid = gl.locationid
6 : where gl.tournamentid = <cfqueryparam value="#qtournament.tournamentid#" cfsqltype="cf_sql_integer" />
7 : </cfquery>
8 : <cfoutput>
|