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
order m.proj_key

i had guess on how wanted match m.category against resource , event_cal, idea.

More discussions in Database Access

adobe