mysql结构不同的表怎么同时显示

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;

SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;

SELECT table1.column1, table2.column2
FROM table1
JOIN table2 ON table1.common_column = table2.common_column;

SELECT column1, (SELECT column2 FROM table2 WHERE table2.common_column = table1.common_column) AS column2
FROM table1;

CREATE VIEW combined_view AS
SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;

SELECT * FROM combined_view;

CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    department_id INT
);

CREATE TABLE departments (
    id INT PRIMARY KEY,
    name VARCHAR(100)
);

SELECT e.name AS employee_name, d.name AS department_name
FROM employees e
JOIN departments d ON e.department_id = d.id;