You are viewing a single comment's thread from:

RE: Have you ever had the need for a JOIN on expression other than = ? #sql ...

in DBuzz3 months ago

So... I guess you mean something other than a single condition (comparison) that returns a true/false statement.
Perhaps an OR condition?
Never had to use that, but I could imagine that being very useful stuff for data-analysis. At which point speed might not be your first concern, meaning you might as well solve that in code...

It's really hard to reply to a DB question without an actual use-case and data.
Generally, I'd leave logic operations to the language you are developing in.
The rest of the logic should be covered by designing the tables well.

Sort:  

No, I mean something like
JOIN ON a > b
or
JOIN ON a <> b

Posted via D.Buzz