从两个表中获取值的Mysql查询

Question

我有两张桌子如下-

table1

mysql>从Access_ID中选择*；

+------------+----------------+
| SERVICE_ID | ACCESS_LIST_ID |
+------------+----------------+
|       1035 |           1040 |
|       1094 |           1134 |

table2

mysql>从剖面中选择*；

+-------+------------------------+-------------+-
| PR_ID | PR_NAME                | PR_PARENTID | PR_TYPE           |
---------------------------------------------------------------------
|  1035 | raj                    |        1022 | name           |
|  1040 | computer               |        1035 | course         |
|  1094 | suresh                 |        1077 | name           |
|  1134 | electronics            |        1077 | course         |

我要求输出低于

表格

| raj      |  computer  |
| suresh   | electronics|

Answer 1

可能是这样的

SELECT T2.PR_NAME AS NAME,T3.PR_NAME AS Serveice
FROM Access_ID T1 JOIN PROFILE T2 ON T1.SERVICE_ID = T2.PR_ID 
                  JOIN PROFILE T3 ON T1.ACCESS_LIST_ID = T3.PR_ID 

小提琴演示

产出将

  +---------+-------------+
  | NAME    | SERVEICE    |
  +---------+-------------+
  | raj     | computer    |
  | suresh  | electronics |
  +---------+-------------+

Answer 2

尝试：

select
    pro1.PR_NAME
   ,pro2.PR_NAME
from 
    Access_ID acs inner join 
    PROFILE pro1 on
        (acs.SERVICE_ID = pro1.PR_ID) inner join
    PROFILE pro2 on
        (acs.ACCESS_LIST_ID = pro2.PR_ID)