Sequel Pro: Full Outer Join

[Ryan O'Donnell]

Am I missing something -- or does Sequel Pro not recognize Full Outer Joins? When I try to use it, I get this error message:

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 table2

on table1.first=table2.first AND table1.last=table2.la' at line 3

 If it does, what am I doing wrong? If it doesn't, any workarounds to get the same results as an outer join?

Thanks!

[Jakob Egger]

This is not a limitation of Sequel Pro, this is a limitation of MySQL.

You can simulate a full outer join using a left join, a right join, and UNION.

See http://stackoverflow.com/questions/4796872/full-outer-join-in-mysql for details

Jakob

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.
To post to this group, send email to seque...@googlegroups.com.
Visit this group at http://groups.google.com/group/sequel-pro.
For more options, visit https://groups.google.com/groups/opt_out.

[Jakob Egger]

This is not a limitation of Sequel Pro, this is a limitation of MySQL.

You can simulate a full outer join using a left join, a right join, and UNION.

See http://stackoverflow.com/questions/4796872/full-outer-join-in-mysql for details

Jakob

Am 06.03.2014 um 23:52 schrieb Ryan O'Donnell <ryanjosep...@gmail.com>: