没有键的mysql连接表 [英] mysql join tables without keys

问题描述

基本问题:如何联接2个表以获取以下输出?

Basic question: How do I join 2 tables to get the following output?

Table1:
"type"
red
blue
big
small

===

Table2:
"object"
cat
person
chair

===

Output:
red cat 
blue cat
big cat
small cat
red person
blue person
big person
small person
red chair
blue chair
big chair
small chair

推荐答案

SELECT * FROM Table1 CROSS JOIN Table2

这篇关于没有键的mysql连接表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！