Hello Firebird-support members,
The firebird-support list is moving to Google Groups. The new location is
https://groups.google.com/d/forum/firebird-support
Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
need to resubscribe yourself, in one of two ways:
(1) If you
Sorry I can't help at all, Kjell, I'm all "old style query plan". Though
I'm baffled by the new style changing when the old style remains and would
love if someone could explain...
Set
fre. 1. mai 2020 kl. 11:56 skrev Karol Bieniaszewski
liviusliv...@poczta.onet.pl [firebird-support] <
You can try also pseudo inner join (left join with where clause)
Instead of
T1 INNER JOIN T2 ON T1.ID1=T2.ID2
change it to
T1 LEFT JOIN T2 ON T1.ID1=T2.ID2
WHERE
T2. ID2 IS NOT NULL
regards,
Karol Bieniaszewski
Well, the changed subselect didn't do the trick, but I think it speeds
up the query slightly, overall.
Now, it's this query that's causing problems:
insert into "TmpFKExportUhant" ("ECO_ID", "Bärartyp")
select FtgOmsar."Uppgiftshanterare", 'FöretagOmsättningsår' "Bärartyp"
from "Företag" F
On 2020-05-01 02:20, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
> The firebirdsql.org site lists new Google groups to replace the yahoo
> firebird-support and firebird-general lists, but the links don't work -
> I get permission denied errors trying to visit them.
>
> Are