InnerJoins

Greg Galipeau

Does the Everlive Power Fields (i.e.: expand relationships) have a concept of InnerJoin?

I have a table called Friends. The Friends table has a relationship field called Users. I need to make a query to get the Friends row for a particular User.

I understand the Filtering concept of the expand. But, that still brings back all my Friends and just has a null for Users in the ones that don't meet the filter (i.e.: an OuterJoin). I need it only to return the Friends that match the User.

Here is how I tried it with the expand/filter (this returns 2 rows. 1 with Users and 1 without. i.e.: OuterJoin):

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.