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.

e.g.
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
TABLEA.FIELDX=TABLEB.FIELDY

There are several items in the online FAQ about this.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________
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.
_______________________________________________________