David Fowler wrote:
Query 2: SELECT * FROM table1, table2 WHERE ((table1.value LIKE "%value%" AND table1.table2_id = table2.id)
> OR (table1.value LIKE "%different_value%" AND table1.table2_id = table2.id)); This query (and even more complex versions of it) works in MySQL (Haven't tried another DB yet) and I'm trying to migrate to > SQLite, this is really holding me back.
Hi David Have you ever tried your statement as following: SELECT * FROM table1, table2 WHERE table1.table2_id = table2.id and (table1.value LIKE "%value%" or table1.value LIKE "%different_value%"); khamis -- Try Code-Navigator on http://www.codenav.com a source code navigating, analysis and developing tool. It supports following languages: * C/C++ * Java * .NET (including CSharp, VB.Net and other .NET components) * Classic Visual Basic * PHP, HTML, XML, ASP, CSS * Tcl/Tk, * Perl * Python * SQL, * m4 Preprocessor * Cobol
