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