我有两个表:
表A:
EmloyeeName
John
Mike
Bruce
表B:
Date
2018-10-25
2018-10-26
2018-10-27
2018-10-28
2018-10-29
2018-10-30
2018-10-31
我想要:
EmployeeName Date
John 2018-10-25
John 2018-10-26
John 2018-10-27
John 2018-10-28
John 2018-10-29
John 2018-10-30
John 2018-10-31
Mike 2018-10-25
Mike 2018-10-26
Mike 2018-10-27
Mike 2018-10-28
Mike 2018-10-29
Mike 2018-10-30
Mike 2018-10-31
...
要使用哪个查询?
您需要CROSS JOIN
:
SELECT a.name, b.date
FROM a CROSS JOIN
b
ORDER BY a.name;
你可以试试这个。
select t1.EmloyeeName,t2.Date
from TableA t1, TableB t2
您可以通过交叉连接来完成,如下所示
SELECT a.name, b.date
FROM TableA a CROSS JOIN
TableB b
ORDER BY a.name;
希望这对你有帮助。