Subject | Re: [firebird-support] avoid query subselect |
---|---|
Author | liviuslivius |
Post date | 2019-07-19T11:26:16Z |
Hi,
i suppose this one is much faster
SELECT P.ID
)
THEN 1 ELSE 0 END AS ISDATA
FROM PARENT P
...........
INNER JOIN TABLE3 T3 ON P.ID=T3.....
INNER JOIN TABLE3 T4 ON P.ID=T4.....
..........
Regards,
Karol Biieniaszewski