| SQL Statement: | SELECT tbl_nt_Contributor.FullName, tbl_nt_Play.PlayName, tbl_nt_Theatre.TheatreName, tbl_nt_Production.ProductionID, tbl_nt_RoleType.RoleName, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From FROM (((((tbl_nt_ProdContrib INNER JOIN tbl_nt_Production ON tbl_nt_ProdContrib.ProductionID = tbl_nt_Production.ProductionID) 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_Contributor ON tbl_nt_ProdContrib.ContributorID = tbl_nt_Contributor.ContributorID) INNER JOIN tbl_nt_Play ON tbl_nt_ProdPlay.PlayID = tbl_nt_Play.PlayID) INNER JOIN tbl_nt_RoleType ON tbl_nt_ProdContrib.RoleTypeID = tbl_nt_RoleType.RoleTypeID WHERE (((tbl_nt_Contributor.ContributorID)=461)) UNION SELECT tbl_nt_Contributor.FullName, tbl_nt_Play.PlayName, tbl_nt_Theatre.TheatreName, tbl_nt_Production.ProductionID, tbl_nt_RoleType.RoleName, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From FROM (((((tbl_nt_Production INNER JOIN tbl_nt_ProdPlay ON tbl_nt_Production.ProductionID = tbl_nt_ProdPlay.ProductionID) INNER JOIN tbl_nt_Play ON tbl_nt_ProdPlay.PlayID = tbl_nt_Play.PlayID) INNER JOIN tbl_nt_Theatre ON tbl_nt_Production.TheatreID = tbl_nt_Theatre.TheatreID) INNER JOIN tbl_nt_PlayAuthor ON tbl_nt_Play.PlayID = tbl_nt_PlayAuthor.PlayID) INNER JOIN tbl_nt_Contributor ON tbl_nt_PlayAuthor.ContributorID = tbl_nt_Contributor.ContributorID) INNER JOIN tbl_nt_RoleType ON tbl_nt_PlayAuthor.RoleTypeID = tbl_nt_RoleType.RoleTypeID WHERE (((tbl_nt_Contributor.ContributorID)=461)) UNION SELECT tbl_nt_Contributor.FullName, tbl_nt_Play.PlayName, tbl_nt_Theatre.TheatreName, tbl_nt_Production.ProductionID, tbl_nt_RoleType.RoleName, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From FROM (((tbl_nt_Production INNER JOIN tbl_nt_Theatre ON tbl_nt_Production.TheatreID = tbl_nt_Theatre.TheatreID) INNER JOIN tbl_nt_ProdPlay ON tbl_nt_Production.ProductionID = tbl_nt_ProdPlay.ProductionID) INNER JOIN (((tbl_nt_Contributor INNER JOIN tbl_nt_VersionContrib ON tbl_nt_Contributor.ContributorID = tbl_nt_VersionContrib.ContributorID) INNER JOIN tbl_nt_RoleType ON tbl_nt_VersionContrib.RoleTypeID = tbl_nt_RoleType.RoleTypeID) INNER JOIN tbl_nt_Version ON tbl_nt_VersionContrib.VersionID = tbl_nt_Version.VersionID) ON tbl_nt_ProdPlay.ProdPlayID = tbl_nt_Version.ProdPlayID) INNER JOIN tbl_nt_Play ON tbl_nt_ProdPlay.PlayID = tbl_nt_Play.PlayID WHERE (((tbl_nt_Contributor.ContributorID)=461))ORDER BY tbl_nt_RoleType.RoleName, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From |