dear friend
i have a two table .
table 1 has 5 column
table 2 has 3 column( this 3 column is same is my table 1's 5 column)
i want to perform a operation that once i fire select statment on table 2. it should compare both
of table and disply the uniqe value from both table
Loading
Jignesh TrivediPosted Mar 2, 2015, 2:33 AM
really do not understand the question but you do not required duplicate column when you join this two table right?
if yes then with select statement you can also specify the column name which you want tobe output
select t1.col1,t1.col2,t1.col3,t2.col4,t2.col5 from tbabl1 t1
inner join table2 t2
on t1.col1 = t2.col1 and t1.col2 = t2.col2 and t1.col3 = t2.col3
hope this will help you.
Manish Kumar ChoudharyPosted Mar 2, 2015, 1:23 AM
left outer join table1
on tbabl2.
PradeepPosted Mar 2, 2015, 1:22 AM