Re: Workaround for subquery limitation in in view creation

[Peter Brawley]

Like this?

select a.name, a.description, group_concat(b.subject) as subjects, group_concat(b.marks) as marks
from a
left join b using(name)
group by a.name, a.description;

Or this?

select a.name, a.description, group_concat( concat(b.subject,':',b.marks) ) as results
from a
left join b using(name)
group by a.name, a.description;