Full Outer Join with all rows

• louislsh

  Old Hand

  Points: 358

  More actions

  March 16, 2020 at 3:40 am

  Go to Answer

  #3734584

  Hi Everyone, I have the following Table A and Table B.

  I tried doing a full outer join in Tableau software but was not successful.

  Could i please check if my desired output below is possible?

  I did not include my code because i uses Tableau to do a auto full outer join with my common key as Store.

  I wish to do this in SQL 2008

  

• handkot

  SSCertifiable

  Points: 5312

  More actions

  March 16, 2020 at 4:37 am

  Answer

  #3734592

  louislsh

  use union

  select [Sales Date], Store, Product, Sold, cast(Null as Int) As SOH From TableA

  union all

  select Null As [Sales Date], Store, Product, Null As Sold, SOH From TableB

  I Have Nine Lives You Have One Only
  THINK!

• louislsh

  Old Hand

  Points: 358

  More actions

  March 16, 2020 at 5:31 am

  #3734597

  Thank you very much! it's working now.

  I am able to show my report for those stocked but not show within a date range.

  Really very very grateful for your kind help.

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  March 17, 2020 at 12:10 pm

  #3734959

  for these types of queries you might want to have a look up the GROUP BY ROLLUP command - it is not used too often, but  it saves you using a union query

  from the Microsoft site here is an example

  

  MVDBA