Re: Outer join/inner join

["draves" <webforumsuser@xxxxxxxxxxxxxx>]

where
 Table2.EventID = Table1.EventID and
 Table2.PromoterID = Table4.PromoterID and
 Table2.LeagueID = Table3.LeagueID 
 <cfif isdefined("form.leagueacronym")>
 <cfif trim(form.leagueacronym) neq ''>
 and table2.eventid in
 (select t2a.eventid from table2 t2a,table3 t3
 where t2a.eventid = table2.eventid 
 and t2a.leagueid =  t3.leagueid
 and t3.leagueacronym = '#form.leagueacronym#')
 </cfif>
 </cfif>