Check out example codes for "sql common columns". It will help you in understanding the concepts better.

Code Example 1

-- NB: Applicable for Oracle and PL/SQL only

select * 
from all_tab_cols A
where 
   A.COLUMN_NAME in 
   (
      select B.column_name
      from all_tab_cols B
      where B.table_name = 'xxx'
   )
   and A.table_name != 'xxx'
   and A.TABLE_NAME = 'yyy';

Learn ReactJs, React Native from akashmittal.com