Alex_Piggy
Advanced Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
Код: SELECT Test1.Name, Test2.Nick, Phone.data ,Email.data
FROM Test1
LEFT OUTER JOIN Test2 ON
Test1.id=Test2.name_id
LEFT OUTER JOIN Test3 Phone ON
Test1.id=Phone.name_id AND Phone.data_type=1
LEFT OUTER JOIN Test3 Email ON
Test1.id=Email.name_id AND Email.data_type=2; |
Результат -
Name|Nick|Phone|EMail
Ivan|Vanja|1_Phone1|1_Email1
Ivan|Vanja|1_Phone2|1_Email1
Ivan|Vanja|1_Phone3|1_Email1
Petr|Petja|2_Phone1|2_Email1
Sidor||3_Phone1|
|
