如何选择和联接带有表的查询 [英] How to select and join on a query with a table

问题描述

我认为这只是Join上的语法问题，但我正在尝试将查询联接到现有表上

I think this is just a syntax issue for me on Join but I am trying to Join a query to an existing table

select *
from
  (
    (select 'Source1' Source from Dual
     union select 'Source2' from Dual
     union select 'Source3' from Dual
     union select 'Source4' from Dual
     )
    cross join (
      select 'O' Status from Dual
      union select 'C' from Dual
     )
    cross join (
      SELECT
      TO_DATE('09/30/2013','mm/dd/yyyy') - 1 + LEVEL dt
      FROM dual
      CONNECT BY
      LEVEL <= ( TO_DATE('10/05/2013','mm/dd/yyyy')
           - TO_DATE('09/30/2013','mm/dd/yyyy')) + 1
     )
  ) as x
left join 
  (
    select myTable.mySource
    from myTable
  ) as y 
on y.err_sts_cd = x.Status

推荐答案

您应该能够删除大部分分组内容...

You should be able to just remove most of the grouping parens...

select *
from
    (select 'Source1' Source from Dual
     union select 'Source2' from Dual
     union select 'Source3' from Dual
     union select 'Source4' from Dual
     ) s
    cross join (
      select 'O' Status from Dual
      union select 'C' from Dual
     ) x
    cross join (
      SELECT
      TO_DATE('09/30/2013','mm/dd/yyyy') - 1 + LEVEL dt
      FROM dual
      CONNECT BY
      LEVEL <= ( TO_DATE('10/05/2013','mm/dd/yyyy')
           - TO_DATE('09/30/2013','mm/dd/yyyy')) + 1
     ) d
left join 
    myTable y
on y.err_sts_cd = x.Status

这篇关于如何选择和联接带有表的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！