Does Glorp Support FULL JOIN ?

[jtuchel]

Hi there, 

title says it all: I'd need to do a FULL JOin of two tables and can't find any info on how to do that. Maybe it's not implemented yet?

Joachim

[Alan Knight]

I had to look up what that was, so I'm pretty sure I never implemented it. Someone else may have. It shouldn't be too awful to add, although it would involve working in expressions. Or you could do it as custom SQL if you don't need to use it in a lot of complicated ways.

--
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glorp-group...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/glorp-group/f5da4d37-0ad4-4d3d-a15d-4b8ee38cfaf9n%40googlegroups.com.

[Esteban Maringolo]

Hi Joachim,

I'm curious: what would a FULL OUTER JOIN operation mean specifically in the context of reading objects, and what goal are you trying to achieve with this functionality?

Thanks,

Esteban A. Maringolo

To view this discussion visit https://groups.google.com/d/msgid/glorp-group/CAGWHZ99NhC50GRy9Xr0Zy8tkyYZDho%3DPW%2BG%2BhsBJwyCc63j%3Dbg%40mail.gmail.com.

[Joachim Tuchel]

Hi Esteban,

well, in that specific case I need to compare two sets of objects that may or may not have a counterpart in the respective other table.  

Your question makes perfect sense and I thought about using an SQL View and map it to a specialized class for this specific case. It's a fresh idea I had last night, so maybe that is the way to go rather than implementing this on the GlorpExpressions level. An object that doesn't exist in the left table but has a counterpart in the right one is probably not something that can be modeled in objects without using some kind of Wrapper or Helper or Association in-between...

Joachim

Am 17.11.25 um 13:45 schrieb Esteban Maringolo:

You received this message because you are subscribed to a topic in the Google Groups "glorp-group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/glorp-group/aV2Pxhc1_o4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to glorp-group...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/glorp-group/CAJMgPCKE9OkGDgX0bvS%3DstFpy1NNS%3DdLeGSFNGgzhE1yH6qa4Q%40mail.gmail.com.

-- 

----------------------------------------------------------------------- 
objektfabrik GmbH                        mailto:jtu...@objektfabrik.de
Fliederweg 1                                 http://www.objektfabrik.de
D-71640 Ludwigsburg                                          HRB 798847
Telefon: +49 7141 56 10 86 0                      Amtsgericht Stuttgart

[Esteban Maringolo]

Hi Joachim,

I'm trying to understand if you want to retrieve "data" from a table (with an OUTER JOIN to another one), or objects.

If instances of ObjectA reference instances of ObjectB and vice versa (via some ID_REF column in each table), what would be the expected result when reading ObjectA or ObjectB?

A #alsoFetch could be useful with a LEFT JOIN, but a FULL JOIN is a different beast entirely and I don't know if it makes sense in that context.

Regards,

Esteban A. Maringolo

To view this discussion visit https://groups.google.com/d/msgid/glorp-group/1cb273d5-fef8-4f12-bb72-adf684cc4af1%40objektfabrik.de.