AVASOFT Interview Question: how to merge two tables in SQL?

Notifications

AVASOFT

how to merge two tables in SQL?

Anonymous

4 Jul 2018

Concat(first col, second col)

Anonymous

4 Dec 2019

Select * from table1, table2 where table1. Common column=table2.common column For example deptno is common column

Anonymous

4 Dec 2019

Select * from table1, table2 where table1. Common column=table2.common column For example deptno is common column