| SQL Statement: | SELECT tbl_nt_Production.ProductionID, tbl_nt_Production.Date_Seen, tbl_nt_Production.Date_From, tbl_nt_Play.PlayName, tbl_nt_Theatre.TheatreName, tbl_nt_Contributor.FullName, tbl_nt_Contributor.ContributorID, (SELECT Count(tbl_nt_ProdContrib.ProductionID) FROM tbl_nt_ProdContrib WHERE (((tbl_nt_ProdContrib.RoleTypeID)=1) AND ((tbl_nt_ProdContrib.ContributorID)= tbl_nt_Contributor.ContributorID))) AS ProdCount FROM (((tbl_nt_ProdContrib INNER JOIN tbl_nt_Production ON tbl_nt_ProdContrib.ProductionID = tbl_nt_Production.ProductionID) INNER JOIN tbl_nt_Contributor ON tbl_nt_ProdContrib.ContributorID = tbl_nt_Contributor.ContributorID) INNER JOIN tbl_nt_Theatre ON tbl_nt_Production.TheatreID = tbl_nt_Theatre.TheatreID) INNER JOIN (tbl_nt_ProdPlay INNER JOIN tbl_nt_Play ON tbl_nt_ProdPlay.PlayID = tbl_nt_Play.PlayID) ON tbl_nt_Production.ProductionID = tbl_nt_ProdPlay.ProductionID WHERE (((tbl_nt_Production.ProductionID)='BRBT0020') AND ((tbl_nt_ProdContrib.RoleTypeID)=1)) ORDER BY tbl_nt_Contributor.LastName, tbl_nt_Contributor.FirstName |