如何从SQL中的两个不同表中获取相同列名的值

问题描述：

如何在 SQL 中从两个不同的表中获取相同列名的值?

How to get values for same column name from two different tables in SQL?

列名是位于这两个表中的emp_id:company,employee.

column name is emp_id loacated in these two tables: company,employee.

答

如果你想要两个表的单独列中的数据，请尝试:

If you want data in seperate columns from two tables then try :

SELECT c.emp_id, emp.emp_id 
FROM company c
INNER JOIN employee emp on c.company_id = emp.company_id

如果你想合并两列数据，那么使用这个:

If you want to merge both columns data then use this :

SELECT emp_id FROM company
UNION
SELECT emp_id FROM employee