World Netball Championships 2007

SELECT TOP 2 d .GameID, d .DateTime, c1.country AS Team1, c2.country AS Team2 FROM Draw AS d INNER JOIN countries AS c1 ON d .Team1 = c1.countryID INNER JOIN countries AS c2 ON d .Team2 = c2.countryID WHERE (d .gamePlayed = 0) SELECT TOP 2 d .GameID, d .DateTime, c1.country AS Team1, Team1Score, c2.country AS Team2, Team2Score FROM Draw AS d INNER JOIN countries AS c1 ON d .Team1 = c1.countryID INNER JOIN countries AS c2 ON d .Team2 = c2.countryID WHERE (d .gamePlayed = 1) ORDER BY d.GameID DESC World Netball Championships 2007

Latest Results Game ##: #GameID# #Team1# #Team1Score# #Team2# #Team2Score#
Current & Next Games Game ##: #GameID# #Team1# vs #Team2# #DateFormat(DateTime, 'dd/mm/yy')# #TimeFormat(DateTime, 'HH:mm')#