|Subject:||Re: self join
|Date:||Sun, 14 Feb 2021 10:03:13 -0500
|From:||"Steven Green" <firstname.lastname@example.org>
that's actually two changeto, and should be two separate queries.. this
changeto or that changeto.. as a scan, it's a simple if this else that.. if
that query works, it shouldn't
Myrtle Beach, South Carolina, USA
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof" wrote in message
I don't (yet) handle multi-row queries so this was rejected:
Vend_Reb | Rebate | Curr | FxRate |
| _r | "USD" | CHANGETO ~FxRate |
| _r | NOT "USD" | CHANGETO 1 |
Easy. Just (for now) split the query.
But whats that _r link intending?
I tried with and without and the results seem to be the same.