TBCC BadgeThree Bridges Cricket Club



Saturdays (League)
May-3May-10

select DISTINCT Matches.Date as Dates from Matches INNER JOIN Reports ON (Matches.Date = Reports.Date) and (Matches.XI = Reports.XI) where (((Matches.XI) = 'TOUR') and ((Matches.Type)='FR')and ((Matches.Date > '2008-Jan-01') and (Matches.Date < '2008-Dec-31')))union select DISTINCT Matches1.Date as Dates from Matches as Matches1 INNER JOIN MatchHead ON (Matches1.Date = MatchHead.Date) and (Matches1.XI = MatchHead.XI) where (((Matches1.XI) = 'TOUR') and ((Matches1.Type)='FR')and ((Matches1.Date > '2008-Jan-01') and (Matches1.Date < '2008-Dec-31')));
Results 2001Results 2002Results 2003Results 2004Results 2005Results 2006Results 2007