关于数据库的外连接内连接,看前面总结的一篇 ~
在Mysql中,如果同时外连接几个表,怎么写呢(语法)~
在mysql中,直接看help就很不错(看来有些知识还是要看书夯实的)
mysql> ?JOIN
显示语法:
SELECT * FROM t1 LEFT JOIN (t2, t3, t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)
is equivalent to:
SELECT * FROM t1 LEFT JOIN (t2 CROSS JOIN t3 CROSS JOIN t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)