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@...]
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/