How to show one table in one click

Question

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

Jignesh Trivedi · Answer

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.col1t1.col2t1.col3t2.col4t2.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 Choudhary · Answer

select * from tbabl2 left outer join table1 on tbabl2. =table1

Pradeep · Answer

Use Joins .. u will get it...