In mysql, what kinds of association queries are there?

Alibaba cloud Q & A 2022-02-13 05:12:53 阅读数:313

mysql kinds association queries

Please elaborate .

Take the answer 1:

Cross connect (CROSS JOIN); Internal connection (INNER JOIN); External connection (LEFT JOIN/RIGHT JOIN); The joint query (UNION And UNION ALL); Full connection (FULL JOIN); Cross connect (CROSS JOIN)

copyright:author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.