What happens if you phrase it like this?
SELECT DISTINCT summary.uid, summary.vcard
FROM folder_id AS summary
LEFT JOIN 'folder_id_email_list' AS email_list
ON email_list.uid = summary.uid
AND email_list.value like 'foo%'
WHERE email_list.value like 'foo%'
OR summary.full_name like 'foo%';
Which of course makes the left join only include records already satisfying the
condition?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
