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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users