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

Notifications

AVASOFT

how to merge two tables in SQL?

Anonymous

Jul 4, 2018

Concat(first col, second col)

Anonymous

Dec 4, 2019

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

Anonymous

Dec 4, 2019

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