时间戳

首页 > 解决方案 > 我想要这两个查询的俱乐部以及所有信息

sql - 我想要这两个查询的俱乐部以及所有信息

问题描述

select r.resource_id,r.resort_id,r.parent_id,r.type,r.code,r.name,r.implicationmanager_id, 
    i.implies_id,i.valid_from,i.valid_to,i.BOOK_FROM,i.BOOK_TO 
from resourcebasei18n r 
join implies i on r.IMPLICATIONMANAGER_ID=i.IMPLICATIONMANAGER_ID;

select i.implies_id,i.valid_from,i.valid_to,i.BOOK_FROM,i.BOOK_TO,
    d.resource_id as implied_resource_id,
    r.resort_id,r.parent_id,r.type,
    r.code as implied_resource_code,
    r.name as implied_resource_name 
from implies i
join implied d on i.implies_id=d.implies_id
join resourcebasei18n r on d.resource_id=r.resource_id;

标签： sqloracle

解决方案

你需要这个吗-

SELECT i.implies_id
      ,i.valid_from
      ,i.valid_to
      ,i.BOOK_FROM
      ,i.BOOK_TO
      ,d.resource_id as implied_resource_id
      ,r.resort_id
      ,r.parent_id
      ,r.type
      ,r.code as implied_resource_code
      ,r.name as implied_resource_name
      ,r.resource_id
      ,r.name
      ,r.implicationmanager_id
FROM implies i
JOIN implied d ON i.implies_id=d.implies_id
JOIN resourcebasei18n r ON d.resource_id=r.resource_id
                        AND r.IMPLICATIONMANAGER_ID=i.IMPLICATIONMANAGER_ID;

如果您需要除此之外的任何内容，请发布一些示例数据和预期结果。

推荐阅读