Discuss / SQL / 对于MySQL不支持FULL OUTER

对于MySQL不支持FULL OUTER

Topic source

select s.id, s.class_id, s.name, c.name class_name, s.gender, s.score from students s left outer join classes c on s.class_id = c.id union select s.id, s.class_id, s.name, c.name class_name, s.gender, s.score from students s right outer join classes c on s.class_id = c.id;


  • 1

Reply