table A recipe_no, d_1 , d_2 , d_3 , d_4 , d_5 231 420 465.9 001 table B IC ENAME 001 Cholera 420 Tc 465.9 TB 这是我现在的2个table 想请问 怎样下sql 让资料呈现出 recipe_no, d_1 ,ENAME , d_2 ,ENAME, d_3 ,ENAME, d_4 ,ENAME, d_5,ENAME ================================================================== recipe_no, d_1 ,ENAME , d_2 , ENAME, d_3 ,ENAME, d_4 ,ENAME,d_5,ENAME 231 420 TC 465.9 TB 001 Cholera 也就是 d_1 至d_5 是对应到 b.ic 然後我要带出他对应的ename 我表达的可能不好 请大家帮忙一下,谢谢 --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 211.72.93.166