Thank you for catching that. Here is the corrected and tested DDL. I did try left join but can't get them lined up the way presented in results (MergedTab).

IF OBJECT_ID('TempDB..#table1') IS NOT NULL DROP TABLE #table1

--===== Create the test table with

CREATE TABLE #table1

(

paytoname varchar (255),

pname varchar (255),

contract1 varchar (255),

Memcount1 int,-- aleady summed up

Paid1 int,-- aleady summed up

plans1 varchar (150),

)

INSERT INTO #table1

(paytoname, pname, contract1,Memcount1,Paid1,Plans1)

SELECT 'American DME','Smith, Frank' , '100%Medi' , '1500', '2400', 'Medplan1'

UNION ALL

SELECT 'ERP DME','Boyd, Carl' , '105%Medi' , '2500', '400', 'Medplan2'

UNION ALL

SELECT 'MOP DME','Falling, Peter' , '100%Medi' , '200', '1400', 'Medplan1'

--Table 2

IF OBJECT_ID('TempDB..#table2') IS NOT NULL DROP TABLE #table2

CREATE TABLE #table2

(

paytoname varchar (255),

pname varchar (255),

contract2 varchar (255),

Memcount2 int,-- aleady summed up

Pcount int,-- aleady summed up

Paid2 int, -- aleady summed up

plans2 varchar (150),

)

INSERT INTO #table2

(paytoname, pname, contract2,Memcount2,Pcount,Paid2,Plans2)

SELECT 'American DME','Smith, Frank' , '101%Med' , '700', '150' , '1200', 'Medplan4'

UNION ALL

SELECT 'ERP DME','Boyd, Carl' , '105%Med' , '900', '600', '175', 'Medplan4'

UNION ALL

SELECT 'MOP DME','Falling, Peter' , '100%Med' , '1200', '3500', '240' , 'Medplan4'

UNION ALL

SELECT 'ASH DME','Ferrari, Shelly' , '90%Med' , '250', '1100', '197','Medplan4'

--Merged Tables Results

IF OBJECT_ID('TempDB..#MergedTab ') IS NOT NULL DROP TABLE #MergedTab

CREATE TABLE #MergedTab

(

paytoname varchar (255),

pname varchar (255),

contract1 varchar (255),

contract2 varchar (255),

Memcount1 int,

Memcount2 int,

Pcount int,

Paid1 int,

Paid2 int,

plans1 varchar (150),

plans2 varchar (150)

)

INSERT INTO #MergedTab

(paytoname, pname, contract1,contract2,Memcount1,Memcount2,Pcount,Paid1,Paid2,Plans1,plans2)

SELECT 'American DME', 'Smith, Frank', '100%Medi', '101%Med', '1500', '700', '150', '2400', '1200', 'Medplan1', 'Medplan4'

UNION ALL

SELECT 'ERP DME', 'Boyd, Carl', '105%Medi', '105%Med', '2500', '900', '600', '400', '175', 'Medplan2', 'Medplan4'

UNION ALL

SELECT 'MOP DME', 'Falling, Peter', '100%Medi', '100%Med', '200', '1200','3500', '1400', '240', 'Medplan1', 'Medplan4'

UNION ALL

SELECT 'ASH DME', 'Ferrari, Shelly', '', '90%Med', '', '250', '1100', '', '197', '', 'Medplan4'

Thank You for reviewin gand giving me directions.

Helal