→ CAnthony15:嗯嗯!!我試試看:) 01/08 17:58
※ 引述《CAnthony15 (CAnthony)》之銘言:
: 如題
: 我現在有資料表
: QTYPE EMQTYPE EMPLOY
: ===================== ================ ===================
: QTYNO QTYPE EMAIL QTYNO EPNO EPNO EPNAME
: --------------------- ---------------- --------------------
: 001 X01 XXX@X 001 01 01 James
: 002 X03 OOO@O 002 02 02 Cafe
: 001 02
: 請問我陷在如果要印出下列樣子!!! 該怎麼處理
: ─>
: 001 X01 XXX@X James,Cafe
: 002 X03 OOO@O Cafe
mysql> select a.QTYNO,a.QTYPE,a.EMAIL,GROUP_CONCAT(c.EPNAME) FROM QTYPE as
a,EMQTYPE as b,EMPLOY as c WHERE a.QTYNO=b.QTYNO and b.EPNO=c.EPNO GROUP BY
a.QTYNO ORDER BY a.QTYNO ASC;
+-------+-------+-------+------------------------+
| QTYNO | QTYPE | EMAIL | GROUP_CONCAT(c.EPNAME) |
+-------+-------+-------+------------------------+
| 001 | X01 | XXX@X | James,Cafe |
| 002 | X03 | OOO@O | Cafe |
+-------+-------+-------+------------------------+
2 rows in set (0.00 sec)
mysql>
好像寫出來了~參考看看^^
--
3WA訓練家的工作室
宗旨:諸葛單中,謝謝
個人佈弱格 網址:http://3wa.tw
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.32.3.210