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 Surname ORDER BY Rank) AS Surname, Street, City, State, Zip, HomePhone, Comments, GROUP_CONCAT(DISTINCT WorkPhone ORDER BY Rank) AS WorkPhone, GROUP_CONCAT(DISTINCT CellPhone ORDER BY Rank) AS CellPhone, GROUP_CONCAT(DISTINCT Email ORDER BY Rank) AS eMail, MAX(Volunteer) AS Volunteer, MAX(ReceivesFlyer) AS ReceivesFlyer, Houmuch, Wherat
FROM Nam RIGHT JOIN Address USING (MemberID) LEFT JOIN Paid USING (MemberID)
GROUP BY MemberID
ORDER BY Surname, GivenName

There are tables "Nam" and "Address", and "Paid" is a view.

But when I try to use it for a table, there is trouble:

mysql> select * from memberp;
ERROR 1250 (42000): Table 'nam' from one of the SELECTs cannot be used in field list

If I leave this, "GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS", out, there is no trouble. If I leave out any of the other like phrases, there is yet trouble. If I leave the "ORDER BY ..." out, there is no trouble.

Only "GivenName" is derived from "GROUP_CONCAT" and is also a lesser field for ordering by. Why is that a problem?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com