Is there any difference in performance ?

--- In ib-support@yahoogroups.com, "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
properly
> 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
possible.
> Alan
> (I may be completely wrong here :-)))
>
> -----Original Message-----
> From: ronaldorezende [mailto:ronaldinho79@b...]
> Sent: Thursday, 6 March 2003 11:16 PM
> To: ib-support@yahoogroups.com
> 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:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/