Hello List:

I have a Paradox query that contains roughly the following syntax,
okay I retyped it, and changed the table and field names to protect
the guilty (me :-).

SELECT
FS.NAME AS FS_NAME,
TS.NAME AS TS_NAME
FROM WAYBILL AS WB
LEFT JOIN SHIPPER AS FS ON FS.SHIP_ID = WB.FROM_SHIP_ID
LEFT JOIN SHIPPER AS TS ON TS.SHIP_ID = WB.TO_SHIP_ID

There is actually about 45 more fields and 10 more tables in this
query, but this should be enough to figure out the problem.

It doesn't like the AS in the FROM or JOIN statements, can this not
be done using IB syntax. I am actually using Firebird 0.9.4.41,
which is supposed to be less buggy.

I was thinking of creating a view on the SHIPPER table, and using
that to get the second part, but I don't want to have to create views
when I don't need them, anyone have an idea?

Paul


Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com