68 : select Entry_List.Yacht_ID, Entry_List.Yacht_Name, Entry_List.Yacht_Sail_1, Entry_List.Yacht_Sail_2, Entry_List.Yacht_Make, Entry_List.Division, Entry_List.Racing_Circle, Entry_List.Class_Alt_Name, *
69 : from Entry_List, ORC_Ratings
70 : where Entry_List.Event_ID = <cfqueryparam cfsqltype="cf_sql_integer" value="#session.eID#">
71 : AND Entry_List.Division = 'ORC'
72 : AND Entry_List.Yacht_ID = ORC_Ratings.Yacht_ID
|