this statement has an extra ; which may be the error. Another thought, when
quoting string literals, it is better to use single quotes('), since double
quotes(") means identifier --column name-- first, string literal second.
John
==========================================
Thanks for the very fast reply John. The extra (;) was a copying and pasting
error on my part when writing out the email and unfortunatly swapping (")
for (') has had no effect on the result of running the query (SQLite still
locks up at 100% CPU usage). The problem appears to lie within the use of
the OR operator when setting conditions accross two tables. So its either
something to do with the JOIN or OR.
Thanks again for the ideas.