Subject Re: [IBO] Joins & TIB_Query
Author Helen Borrie
At 06:03 AM 27-11-00 +1000, you wrote:
>Hi all,
>Using TIB_Query's editor to add multiple tables to the SQL (and filling in
>the JoinLinks) seems to produce a JOIN...WHERE statement (which bombs out),
>rather than a JOIN....ON statement. Can you produce a proper JOIN using the
>editor, or do I have to manually assign the correct SQL?
>IBO 3.6Be, BCB5/Update1, IB5.6

Joinlinks has only one, confined use. It is for old, SQL-89-style implicit
inner join statements, to identify which of the WHERE parameters are the
join criteria. You can't use it to manipulate a join statement.

select a.field1, b.field2...
from tablea a, tableb b
where a.fieldx = b.fieldy
and b.fieldz=99

In this example, the Joinlinks would be

There are several items in the online FAQ about this.


All for Open and Open for All
InterBase Developer Initiative ยท
When many eyes consider your database support problem, you
benefit from the responses of your peers. We all benefit because
our knowledge base grows.

I will not respond to private requests for free support.