作者virtually (垃圾)
看板Database
标题Re: [SQL ] 不知道如何下语法
时间Fri Oct 6 15:45:37 2006
※ 引述《retsamsu (haha)》之铭言：
: 不知道这样可不可以...试试看
: SELECT T1.course,
: (SELECT T21.content FROM Table_2 AS T21, T1 WHERE T1.name_1 = T21.name),
: (SELECT T22.content FROM Table_2 AS T22, T1 WHERE T1.name_2 = T22.name),
: (SELECT T23.content FROM Table_2 AS T23, T1 WHERE T1.name_3 = T23.name)
: FROM Table_1 AS T1
: 可能写错了，不过就是Select再Select这样
谢谢你
不过这样会有子查询传回不只1个值的问题
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.131.50.135