Subject | Re: [IBO] Links question |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-06-26T12:48:19Z |
>OK - thanks. I won't bother to RTFM then :-)
>No, you should avoid SQL-89 (implicit) joins like the plague. If you do
>avoid them, JoinLinks has no function whatsoever.
>Another "no-no" is what's termed "mixed syntax". It's bad SQL and theAfter this was pointed out to me on the Firebird forum, I have gone through
>parser should bump it (as I *think* the Fb 1.5 parser does now do). It
>looks like this:
>
>select t1.pk1, t1.pk2, t1.col1, t1.col2, t2.cola, t2.colb
>from atable t1
>join btable t2
>on t2.fk1 = t1.pk1
>where t2.fk2 = t1.pk2 <-- a join criterion is pushed down into a where clause
my SQL and eliminated all.
Thanks again
Tim
[Non-text portions of this message have been removed]