| SQL Statement: | SELECT tbl_nt_Production.ProductionID, tbl_nt_Theatre.TheatreName, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From, tbl_nt_Play.PlayName FROM ((tbl_nt_Production INNER JOIN tbl_nt_ProdPlay ON tbl_nt_Production.ProductionID = tbl_nt_ProdPlay.ProductionID) INNER JOIN tbl_nt_Theatre ON tbl_nt_Production.TheatreID = tbl_nt_Theatre.TheatreID) INNER JOIN tbl_nt_Play ON tbl_nt_ProdPlay.PlayID = tbl_nt_Play.PlayID ORDER BY tbl_nt_Theatre.TheatreID, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From |