well the alternative to full outer join is a union of two outer joins - more tedious. “full outer join” isn’t in the library but you can just subclass Join and do a @compiles to get that exact syntax.
On Dec 2, 2013, at 2:05 PM, Chris Withers <ch...@simplistix.co.uk> wrote: > I have a self join (same one I've been asking about recently) and turns out > that there should be a one to one mapping for the aggregated rows on one side > to the aggregated rows on the other side. > > If that's not true, then the returned rows are rubbish. In all my current use > cases it *should* be true but I'm looking for a join that will show me when > something has changed by having nulls in either the left or right side of the > join. > > If you can suggest a way that doesn't involve a full outer join, I'm all ears > :-) > > On 01/12/2013 22:20, Michael Bayer wrote: >> I have a similar question - why ? >> >> >> On Dec 1, 2013, at 5:08 PM, Chris Withers <ch...@simplistix.co.uk> wrote: >> >>> This feels like a newbie question, but how would I do a full outer join in >>> SQLAlchemy? >>> >>> Chris >>> >>> -- >>> Simplistix - Content Management, Batch Processing & Python Consulting >>> - http://www.simplistix.co.uk >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to sqlalchemy+unsubscr...@googlegroups.com. >>> To post to this group, send email to sqlalchemy@googlegroups.com. >>> Visit this group at http://groups.google.com/group/sqlalchemy. >>> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > - http://www.simplistix.co.uk > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out.
signature.asc
Description: Message signed with OpenPGP using GPGMail