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

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') Igor Tandetnik wrote: Alexandre Guion <[EMAIL PROTECTED]> wrote: SELECT m.MediumID AS id, IFNULL(pn.Text, '') AS name, IFNULL(pv.Text, '') AS value FROM Media

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

Alexandre Guion <[EMAIL PROTECTED]> wrote: SELECT m.MediumID AS id, IFNULL(pn.Text, '') AS name, IFNULL(pv.Text, '') AS value FROM Media AS m LEFT JOIN MediumPropMap AS mpm ON mpm.MediumID=m.MediumID LEFT JOIN Property AS p ON mpm.PropID=p.PropID LEFT JOIN PropName AS pn ON