SELECT Members.ID AS ViewField1, Members.First AS ViewField2, Members.Last AS ViewField3, Members.Email AS ViewField4, Members.Joined AS ViewField5, Members.Ends AS ViewField6, Members.ID AS ID_Field
FROM Members
WHERE Members.ID = #URL.RecordID#
pclubmembers - View Record
pclubmembers View Record Search