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 A
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 p.PropNameID=pn.PropNa
2 matches
Mail list logo