Create Table dup1 
(
Temp_id varchar2(10) primary key, 
Temp_desc varchar2(100)
)

Insert into dup1 values('1', 'Positve Statements')

Insert into dup1 values('2', 'Negative Statements')

Insert into dup1 values('3', 'Neutral')


Create Table Dup2
(
dup_id varchar2(10), --primary key,
Temp_id varchar2(10), --references dup1(Temp_id),
Temp_desc1 varchar2(100)
)

Insert into dup2 values('1', '1', 'like lady gaga songs')

Insert into dup2 values('2', '1', 'like lady gaga songs')

Insert into dup2 values('3', '1', 'like lady gaga songs')

Insert into dup2 values('4', '2', 'dont like lady gaga songs')

Insert into dup2 values('5', '2', 'dont like lady gaga songs')

Insert into dup2 values('6', '2', 'dont like lady gaga songs')

Insert into dup2 values('7', '3', 'i am not sure')

Select distinct Dup1.Temp_Desc, Dup2.Temp_desc1
From Dup1, Dup2
Where Dup1.Temp_Id=Dup2.Temp_id