Subject RE: [ib-support] sql - diference in join tables
Author Alan McDonald
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

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.
(I may be completely wrong here :-)))

-----Original Message-----
From: ronaldorezende [mailto:ronaldinho79@...]
Sent: Thursday, 6 March 2003 11:16 PM
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