[sqlite] Re: Re: Select with left outer join - Am I going mad ? Second edition

2006-12-14 Thread Igor Tandetnik
Alexandre Guion <[EMAIL PROTECTED]> wrote: I tried this one of course, and it doesn't work, it could be a bug. It returns every property for every medium (not just 'myprops') This one is tested and appears to work: SELECT m.MediumID AS id, IFNULL(MAX(pn.Text), '') AS name, IFNULL(MAX(

Re: [sqlite] Re: Re: Select with left outer join - Am I going mad ? Second edition

2006-12-13 Thread Alexandre Guion
I don't know how sqlite handles parenthesis in joins. the first query is not recognized by the syntax (mpm.MediumID undefined). The second one just returns ids with name and value being empty. However I only use 3.3.4, is there any documentation on this ? Igor Tandetnik wrote: Alexandre Guio

[sqlite] Re: Re: Select with left outer join - Am I going mad ? Second edition

2006-12-13 Thread Igor Tandetnik
Alexandre Guion <[EMAIL PROTECTED]> wrote: I tried this one of course, and it doesn't work, it could be a bug. It returns every property for every medium (not just 'myprops') I believe this should work (untested): SELECT m.MediumID AS id, IFNULL(pn.Text, '') AS name, IFNULL(pv.Text, '') AS val