Re: [sqlite] Re: Re: An SQL question (Not directly related to SQLite)

On Saturday, January 27, 2007, 10:10:27 PM, Igor Tandetnik wrote: > [EMAIL PROTECTED] wrote: >> Actually, my query is something like >> SELECT ... FROM ... WHERE `pid` = (SELECT `id` FROM ...); >> if i put that group by... will it group all rows, or only those with >> the

[sqlite] Re: Re: An SQL question (Not directly related to SQLite)

[EMAIL PROTECTED] wrote: Actually, my query is something like SELECT ... FROM ... WHERE `pid` = (SELECT `id` FROM ...); if i put that group by... will it group all rows, or only those with the same pid? GROUP BY works on whatever rows remain after WHERE test. Igor Tandetnik