TRC Member Index

Member Index

SELECT RosterWeb.ID, RosterWeb.DNNID, RosterWeb.Entry_Date, RosterWeb.Street_Address, RosterWeb.City, RosterWeb.State, RosterWeb.Zip, RosterWeb.Home_Phone, Persons.Work_Telephone, Persons.Mobile_Telephone, Persons.Email, RosterWeb.Life_Time_Waiver_Signed, RosterWeb.Notes, RosterWeb.UpdateMemberID, RosterWeb.UpdateTime, RosterWeb.UpdateIP, Persons.Gender, RosterWeb.LastFYID, RosterWeb.MembershipTypeID, Persons.First_Name, Persons.Last_Name, RosterWeb.StatusID, Persons.Whole_Name, Persons.RelationshipID FROM Persons INNER JOIN RosterWeb ON Persons.MemberID = RosterWeb.ID Where Persons.RelationshipID = 1 AND RosterWeb.statusid = 1

SELECT RosterWeb.ID, RosterWeb.DNNID, RosterWeb.Entry_Date, RosterWeb.Street_Address, RosterWeb.City, RosterWeb.State, RosterWeb.Zip, RosterWeb.Home_Phone, Persons.Work_Telephone, Persons.Mobile_Telephone, Persons.Email, RosterWeb.Life_Time_Waiver_Signed, RosterWeb.Notes, RosterWeb.UpdateMemberID, RosterWeb.UpdateTime, RosterWeb.UpdateIP, Persons.Gender, RosterWeb.LastFYID, RosterWeb.MembershipTypeID, Persons.First_Name, Persons.Last_Name, RosterWeb.StatusID, Persons.Whole_Name, Persons.RelationshipID FROM Persons INNER JOIN RosterWeb ON Persons.MemberID = RosterWeb.ID Where Persons.RelationshipID = 1 AND RosterWeb.statusid = 1