如何在没有关系的情况下查询每年的课程级别mysql？表1
id course 1 DBA 2 BSCS
表2
id level 1 first year 2 second year 3 third year 4 fourth year
见下图预期输出在此处输入图像描述
1mrurvl11#
你需要做什么 cross join ```select t1.course, t2.level from table_1 t1 cross join table_2 t2
cross join
1条答案
按热度按时间1mrurvl11#
你需要做什么
cross join```select t1.course, t2.level from table_1 t1 cross join table_2 t2