Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 5 of 5 total |
JOINs |
Thu, May 23 2013 10:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I know that theoretically tests other than = can be applied to a JOIN condition. How often does anyone do so?
Roy Lambert |
Fri, May 24 2013 7:49 AM | Permanent Link |
Matthew Jones | I don't think I ever have, but then I'm not a particularly big or fancy user of
databases. /Matthew Jones/ |
Fri, May 24 2013 8:47 AM | Permanent Link |
Raul Team Elevate | 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 > |
Fri, May 24 2013 11:44 AM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Sun, May 26 2013 3:28 AM | Permanent Link |
Roy Lambert NLH Associates 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |