mysql中的全外连接为何报错~该如何解决

mysql中的全外连接为何报错~

select   *   from   tbl1   full   outer   join   tbl2   on   tbl1.id=tbl2.no;

ERROR   1064   (42000):   You   have   an   error   in   your   SQL   syntax;   check   the   manual   that   corresponds   to   your   MySQL   server   version   for   the   right   syntax   to   use   near   ‘outer   join   tbl2   on   tbl1.id=tbl2.no ‘   at   line   1



sql语法错了吧,

select tbl1.* from tbl1 full outer join tbl2 on tbl1.id=tbl2.no;

mysql中的全外连接为何报错~该如何解决

相关文章:

你感兴趣的文章:

标签云: