I certainly feel like I'm going crazy - I just cannot get this to work and I can't see
why.  Here's the SQL:

SELECT b.ocrfilename, b.ocrfilepath, b.ocrpageno, c.acsdoclevel, c.acsdocdate, c.doctype,
d.acddocinfo, c.docsubtype, c.acsdocitemref, c.acsdocinfo, b.ocrxytext, c.acsdref,
i.aciimg_type, p.ocrpagex, p.ocrpagey
FROM ocrcrossref a INNER JOIN imageocrtext b ON b.ocrref = a.ocrref
INNER JOIN fullsubdocumentdetails c ON c.acsdref = a.sdref
INNER JOIN documentdetails d ON d.acddref = a.TLDREF
INNER JOIN imagereferences i ON  i.aciref = a.imglinkref
LEFT JOIN imageocrtextpagedimns p ON p.ocrref = a.ocrref
WHERE TEXTSEARCH('jaeger' IN b.ocrtext)
ORDER BY c.acsdocdate

I have rewritten this I don't know how many times but even if I remove all the table
aliases I get the same or similar error 'table correlation name a in JOIN clause is
invalid in SELECT SQL statement at line 5, column 45'

Can anybody put me out of my misery.  If it's not my syntax but perhaps something to do
with the tables I can supply them..

Thanks in advance
Dave

Dave,

<< I have rewritten this I don't know how many times but even if I remove
all the table aliases I get the same or similar error 'table correlation
name a in JOIN clause is invalid in SELECT SQL statement at line 5, column
45' >>

Just to be sure that there isn't any re-formatting of your post, which line
is that in the SQL statement that you posted ?

<< Can anybody put me out of my misery.  If it's not my syntax but perhaps
something to do with the tables I can supply them.. >>

Send the tables to support@elevatesoft.com and I'll try the query here and
see what I can find.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim
>
> Just to be sure that there isn't any re-formatting of your post,
> which line is that in the SQL statement that you posted ?

The last inner join before the left join
>
> << Can anybody put me out of my misery.  If it's not my syntax but
> perhaps something to do with the tables I can supply them.. >>
>
> Send the tables to support@elevatesoft.com and I'll try the query
> here and see what I can find.

To follow shortly

Dave

Dave,

<< To follow shortly >>

Thanks.  I'll let you know what I find as soon as I receive them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Dave,
>
> << To follow shortly >>
>
> Thanks.  I'll let you know what I find as soon as I receive them.

Hi Tim

I sent them by email (support@elevatesoft.com) on the 11th at 10:26,
subject: "tables for bug(?) reported in dbisam.sql group"

Regards
Dave

Dave,

<< I sent them by email (support@elevatesoft.com) on the 11th at 10:26,
subject: "tables for bug(?) reported in dbisam.sql group" >>

Try resending it again.  I'm showing an email from you being blocked on the
11th at that time, but you are now on our whitelist so you should be able to
send attachments to us.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Dave,
>
> << I sent them by email (support@elevatesoft.com) on the 11th at
> 10:26, subject: "tables for bug(?) reported in dbisam.sql group" >>
>
> Try resending it again.  I'm showing an email from you being blocked
> on the 11th at that time, but you are now on our whitelist so you
> should be able to send attachments to us.

Hi Tim

I resent at 23:41 on the 14th, did it get through?

Dave

Dave,

<< I resent at 23:41 on the 14th, did it get through? >>

Yes, I got it, thanks.  I'll be looking at it this afternoon, and I'm
planning a new DBISAM build later this week.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Dave,
>
> << I resent at 23:41 on the 14th, did it get through? >>
>
> Yes, I got it, thanks.  I'll be looking at it this afternoon, and I'm
> planning a new DBISAM build later this week.

OK look forward to hearing good news!

Cheers
Dave

Dave,

<< OK look forward to hearing good news! >>

Okay, the issue is that this column:

aciref

doesn't actually exist in the imagereferences table.  The weird error
message is caused by the fact that the join verification can't find the
column in order to validate the join ordering.  I'll see what I can do to
get a proper error message thrown that indicates that the column doesn't
exist.

--
Tim Young
Elevate Software
www.elevatesoft.com