需求:MySQL 查询两个不相关的表的数据将其合并输出成一条
实现:
SELECT
t1.*, t2.*
FROM
(
SELECT
*
FROM
t_name1
WHERE
id = 996
) t1,
(
SELECT
*
FROM
t_name2
WHERE
NAME = "007"
) t2
需求:MySQL 查询两个不相关的表的数据将其合并输出成一条
实现:
SELECT
t1.*, t2.*
FROM
(
SELECT
*
FROM
t_name1
WHERE
id = 996
) t1,
(
SELECT
*
FROM
t_name2
WHERE
NAME = "007"
) t2