Subject Re: sql - diference in join tables
Author ronaldorezende
Is there any difference in performance ?

--- In, "Alan McDonald" <alan@m...> wrote:
> reading the IBO documents tells me that the id1=id2 syntax is the
older SQL
> format which is also supported by IB/FB
> The explicit JOIN syntax is newer and (allows IBO anyway) to do some
> intelligent things with you SQL e.g. create an update statement
> without you having to edit it to correct something it may have
> misunderstood.
> Either syntax will bring back the same result in most cases
(barring other
> differences in your statement).
> But I think you should be encrouaged to use the JOIN syntax where
> Alan
> (I may be completely wrong here :-)))
> -----Original Message-----
> From: ronaldorezende [mailto:ronaldinho79@b...]
> Sent: Thursday, 6 March 2003 11:16 PM
> To:
> Subject: [ib-support] sql - diference in join tables
> Is there any diference in sql joins using where id1 = id2 or using
> the left command ?
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to