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(
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
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
3 matches
Mail list logo