|Subject:||Re: self join
|Date:||Sun, 14 Feb 2021 00:51:42 +0000
|From:||Michael Kennedy <Info@KennedySoftware.ie>
I haven't tried that, Bernie, but maybe PDoxDOS will reject the query
with something like "Query has unrelated Rows...", if the "_r" is omitted?
On the other hand, is the query seeking rows where it'll change the
FxRate, only if it finds some rows with USD, A-N-D some without USD, for
the SAME Rebate code? If so, then, if all the entries for a Rebate code
have USD, or if all the entries do not have USD, it will not change the
Or am I totally confusssssed?!!
Running separate queries sounds OK to me, though it might be a little
slower on large tables.
On 13/02/2021 07:09, Bernie van't Hof wrote:
> 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.
> - Bernie