Hello, All.

I've got a trouble. My LinksSQL 2.0.4 is on Oracle8.1.7, and it doesn't repair my tables. I even know why: Oracle doesn't know such SQL words like LEFT OUTER JOIN, and function build_orphan_check use it!

Look at the error i've got:

GT::SQL::error = Failed to prepare query: '
SELECT wdLinks.Title, wdLinks.ID
FROM wdLinks LEFT OUTER JOIN wdCatLinks ON wdCatLinks.LinkID = wdLinks.ID
WHERE (wdCatLinks.LinkID IS NULL)

Instead of it, we should use, for example, the following SQL-operator in Oracle:

select title, id
from wdlinks
where not exists (select id from wdcatlinks where wdlinks.id = wdcatlinks.id)

but we cannot execute this operator with GT::SQL::Table...

Can you help us?

With respect,
Anton Permyakov