Is there any difference in the performance?


--- In ib-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:

> Ronaldo,
>
> At 12:16 06.03.2003 +0000, you wrote:
> >Is there any diference in sql joins using where id1 = id2 or using
> >the left command ?
>
> it is up to you whether you prefer to use WHERE ID1 = ID2 or JOIN

<TABLE>

> ON ID1 = ID2. The first is SQL-89, whereas the second is SQL-92.

Generally,

> I would advice to use the JOIN syntax since it is easier to read

and e.g.

> eliminates the need for JoinLinks if you are using IBO.
>
> LEFT JOIN, RIGHT JOIN and FULL JOIN, however, are outer joins that

gives

> all records of at least one table regardless of whether they match

any

> record in the other table. These are joins that are not available

in

> SQL-89, hence there is no way you can perform these kinds of joins

using

> ID1 = ID2.
>
> HTH,
> Set