; 2011/10/20 10:21 -0400, Shawn Green (MySQL)
On 10/19/2011 17:50, wrote:
I made this query a view, called MEMBERP, no problem:
...snip...
Only GivenName is derived from GROUP_CONCAT and is also a lesser field for
ordering by. Why is that a problem?
Perhaps it is the USING clause that is
Hello Hal�sz S�ndor,
On 10/19/2011 17:50, wrote:
I made this query a view, called MEMBERP, no problem:
SELECT MemberID, ereStart, DateModified, MembershipExpires, MemberSince,
Category, Boardster, GROUP_CONCAT(DISTINCT Salutation ORDER BY Rank) AS
Salutation, GROUP_CONCAT(DISTINCT GivenName
I made this query a view, called MEMBERP, no problem:
SELECT MemberID, ereStart, DateModified, MembershipExpires, MemberSince,
Category, Boardster, GROUP_CONCAT(DISTINCT Salutation ORDER BY Rank) AS
Salutation, GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS GivenName,
GROUP_CONCAT(DISTINCT