Inner join query syntax
i have query, however... need 'category' variable 'like' way have set doent work. have idea of how might fix this. <cfquery name="getworkshops" datasource="source"> select m.category, m.proj_key, m.project, r.proj_key, r.url, r.category, r.end_date, r.title, e.event_date, e.event_date_end, e.category, e.proj_key (main m inner join resource r on m.category r.category)inner join event_cal e on m.category e.category m.category '%workshop%' , m.proj_key=r.proj_key , m.proj_key = e.proj_key order m.proj_key </cfquery> you move join statements clause: select m.category, m.proj_key, m.project, r.proj_key, r.url, r.category, r.end_date, r.title, e.event_date, e.event_date_end, e.category, e.proj_key from main m, resource r, event_cal e where m.category '%'+r.category+'%' and m.category '%" + e.category + '%' and m.category '%workshop%' , m.proj_key=r.proj_key , m.proj_key = e.proj_key ord...