Re: [sqlite] SQL question with SQLite

On Tue, Dec 09, 2008 at 04:58:38PM +0100, jm cuaz scratched on the wall: > In a SELECT statement with multiple tables, is it possible to replace > WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses > (with the same criteria) for the same purpose (no cross join) ? No.

Re: [sqlite] SQL question with SQLite

If you want help with your SQL. You should post it along with your question. There are a lot of really good SQL experts on here that will be able to help you. --- On Tue, 12/9/08, jm cuaz <[EMAIL PROTECTED]> wrote: > From: jm cuaz <[EMAIL PROTECTED]> > Subject: [sq

[sqlite] SQL question with SQLite

Hello, In a SELECT statement with multiple tables, is it possible to replace WHERE clauses used to avoid cross joins with GROUP BY + HAVING clauses (with the same criteria) for the same purpose (no cross join) ? Are the two methods roughly equivalent in performance ? We ask this because we