I know that theoretically tests other than = can be applied to a JOIN condition. How often does anyone do so?

Roy Lambert

I don't think I ever have, but then I'm not a particularly big or fancy user of
databases.

/Matthew Jones/

I don't recall ever using anything other than =

I've used the WHERE clause with some other DB's before but even then it
was = again for key comparison and rest was something else (same as JOIN
WHERE clause).


Raul

On 5/23/2013 10:33 AM, Roy Lambert wrote:
> I know that theoretically tests other than = can be applied to a JOIN condition. How often does anyone do so?
>
> Roy Lambert
>

Roy,

It's not something I had often used, but there were a few times that I did use <>, when there is the need to get pairs of values with distinct values, like this:

(1,2)
(1,3)
(2,1)
(2,3)
(3,1)
(3,2)

--
Fernando Dias
[Team Elevate]

Thanks you lot. Its for specifying joins in my end user query generator. The current version allows the programmer setting up the spec to use anything but I have only use = so its a bit of simplification.

Roy Lambert