SQL search same columns

orders & point_users same colums

 

with

table1 as (select column_name from information_schema.columns

where table_name = 'orders'),

table2 as (select column_name from information_schema.columns

where table_name = 'point_users')

select t1.column_name as '중복 테이블' from table1 t1

inner join table2 t2 on t1.column_name = t2.column_name;