OraFAQ Forum: SQL & PL/SQL » Union??? or Merge of tables

Home » SQL & PL/SQL » SQL & PL/SQL » Union??? or Merge of tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Union??? or Merge of tables [message #611172]

Fri, 28 March 2014 14:48

ertweety11
Messages: 9
Registered: March 2014

Junior Member

I have two tables of data that I want to merge together.

Table 1 (DESKTOP TABLE)
DT KEYCODES TL_DESKTOP TL_DIST
3/1/2014 CL Decrease, No Reversal-Stmt Message 1 1
3/1/2014 CL Decrease, Reversal-Letter 3 3
3/1/2014 CL Decrease, Reversal-Stmt Message 37 32

Table 2 (IVR TABLE)
DT KEYCODES TL_IVR TL_DIST_ACCTS
3/1/2014 CL Decrease, Reversal-Letter 4 3
3/1/2014 CL Decrease, Reversal-Stmt Message 56 56

Basically I would like the new table to display as follows;

DT KEYCODES TL_DESKTOP TL_DIST TL_IVR TL_DIST_ACCTS
3/1/2014 CL Decrease, No Reversal-Stmt Message 1 1 0 0
3/1/2014 CL Decrease, Reversal-Letter 3 3 4 3
3/1/2014 CL Decrease, Reversal-Stmt Message 37 32 56 56

Report message to a moderator

Re: Union??? or Merge of tables [message #611173 is a reply to message #611172]

Fri, 28 March 2014 14:53

John Watson
Messages: 8928
Registered: January 2010
Location: Global Village

Senior Member

You have already been asked to read our OraFAQ Forum Guide and to read How to use [code] tags and make your code easier to read
You have also been asked to provide a test case: CREATE TABLE and INSERT statements.

Report message to a moderator