日期:2014-05-16  浏览次数:20759 次

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;