Non-equal joins

[JohnM]

Does Caspio support creating views that use unequal (“non-equi”) joins?

It seems not.

[IamNatoyThatLovesYou]

Hello @JohnM, you may use "not equal" instead as a criteria when creating views.

[JohnM]

@IamNatoyThatLovesYou, that is not the same as specifying the conditions of the join. It cannot be used to create a NON EQUI JOIN.

To even get to that filter, you need to first specify an equals-based INNER or OUTER JOIN. 

There would need to be options where there is now only “=” in the attached image.

No?

[CoopperBackpack]

Hello @JohnM,

You are correct. I am afraid that non-equal joins are not supported in Views.

You may post your idea here http://ideabox.caspio.com

I assume that this option is not available since it is rarely used.  You may try to achieve the expected result by using some type of join and adding the Criteria to filter the set of data.
 

[JohnM]

Thanks.

I myself would say unequal joins are uncommon. I wouldn’t say rare.

Using Criteria for this would work only if Caspio allowed views on unjoined tables.