Hi,

I'm not sure about how to model the following case:

- I have business objects (vendors) and make a comparison of each pair of them, so a comparison is always related to two business objects
- The comparison is symetric, so I only want to have one comparison dataset: aRb or bRa but not both.
- I need a query which gets a business object (a) and returns all other business objects (b), so that a comparison result exists: aRb or bRa

Has anyone a hint how to model this cleanly? Currently I have a result object with two fields for the business object, but with that I always have to write something like "select result.firstVendor where result.secondVendor = paramValue union select result.secondVendor where result.firstVendor = paramValue"...

Thanks in advance,

Thorsten