Monthly Archives: October 2017

SQL Azure – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

Following on from the previous post I wanted to know the syntax for SQL to do the same but in SQL Azure. SELECT * FROM dbo.T02AttendanceGame T1 WHERE Attendance = ( SELECT max(Attendance) FROM dbo.T02AttendanceGame T2 WHERE T1.FKID=T2.FKID ); I … Continue reading

Posted in All, SQL Azure | Comments Off on SQL Azure – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

MS Access – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

So we have a table of Stadiums and a table of attendances. We would like to create a query that shows an individual child record for each stadium of the highest attendances. Quite often you seek the latest or earliest … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on MS Access – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value