Alex_Piggy
Advanced Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
Код:
.separator ;
SELECT
Name.name AS Name,
Nick.nick AS Nick,
group_concat(Phone.data,';') AS 'Phone1',
substr(';;;;',COUNT(Phone.data)+1) AS 'Phone2;Phone3;Phone4;Phone5',
Email.data AS EMail
FROM test1 Name
LEFT OUTER JOIN test2 Nick
On Nick.name_id=Name.id
LEFT OUTER JOIN test3 Phone
ON Phone.name_id=Name.id And Phone.data_type=1
LEFT OUTER JOIN test3 Email
ON Email.name_id=Name.id And Email.data_type=2
GROUP BY Name.id;
|
|
