Re: Outer join/inner join

["maslinc" <webforumsuser@xxxxxxxxxxxxxx>]

draves that almost does it except - when they search for the league, the input 
is by the league acronym (ABC) rather than the league id.  So once the query 
gets to the table2a.leagueid = '#form.league#' it throws an errow since the 
form information is ABC rather than an integer.  

 Table 2 only has the eventid and leagueid and table 3 has the leagueid and 
leagueacronym in it.  Is there a way to do a subquery that will find the 
correct leagueid from table 3 based on the acronym that is input and then do 
the subquery on table 2 to output all the eventids associated with the leagueid 
and then all the leagueids in the table associated with each event?

 Thanks.