Access DB:
TableA:
ID, team, group, date, time, game, result, city, country
Need a query that extracts the last (max (date plus time)) game a team has played where city name starts with "abc" or "def".
select ID, team, group, date, time, game, result, city from TableA .....
:banghead:
TableA:
ID, team, group, date, time, game, result, city, country
Need a query that extracts the last (max (date plus time)) game a team has played where city name starts with "abc" or "def".
select ID, team, group, date, time, game, result, city from TableA .....
:banghead: