具有内部联接的ORACLE Listagg(ORACLE Listagg with an Inner Join)

 我需要从两个值匹配的两个表中提取数据。 连接表产生5行，并且总是产生5行。 
 
 有没有办法让我可以使用一个具有不同值的列并在一行中返回多个列？ 
 
 例如：表A：orig_zip，dest_zip，pri_mode 
 
 表B：orig_zip，dest_zip，serv_comm 
 
 在执行内部连接时，表B将始终为表A中的每1个结果返回5个结果，如下所示： 
 
SELECT a.orig_zip, a.dest_zip, b.serv_comm, a.pri_mode
FROM A a
INNER JOIN B b
ON a.orig_zip = b.orig_zip and a.dest_zip = b.dest_zip
ORDER BY a.orig_zip, a.dest_zip, b.mail_class;
 
 如何获取5个结果，并将它们转换为oracle中的单个行。 结果中唯一不同的字段是serv_comm字段。 
 
 最后一行应该具有以下设置： 
 
 [ORIG_ZIP] [DEST_ZIP] [SERV_COMM1] [SERV_COMM2] [SERV_COMM3] [SERV_COMM4] [SERV_COMM5] [PRI_MODE] 

I need to pull data from two tables where two values match. The joining table produces 5 rows, and will always produce 5 rows.
 
Is there a way that I can take one column with distinct values and return multiple columns in a single row?
 
For an example: Table A: orig_zip, dest_zip, pri_mode
 
Table B: orig_zip, dest_zip, serv_comm
 
Table B will always return 5 results for every 1 result in Table A when doing an inner join like the following: 
 
SELECT a.orig_zip, a.dest_zip, b.serv_comm, a.pri_mode
FROM A a
INNER JOIN B b
ON a.orig_zip = b.orig_zip and a.dest_zip = b.dest_zip
ORDER BY a.orig_zip, a.dest_zip, b.mail_class;
 
How can I take the 5 results, and turn them into a single row in oracle. The only field that is different in the results will be the serv_comm field.
 
The final row should have the following setup:
 
[ORIG_ZIP][DEST_ZIP][SERV_COMM1][SERV_COMM2][SERV_COMM3][SERV_COMM4][SERV_COMM5][PRI_MODE]

原文：https://stackoverflow.com/questions/22355590