Hi,

I have the following SLQ statement:

select cast(st.Code as varchar(10)) + cast(t.Code as varchar(10)) as Id,
 st.Code as StaffCode, st.FullName, t.Code as SkillCode,
t.DescriptionLong,s.AchieveMethod
into memory SkillsMatrix
from Staff st, TableCode t
left outer join Skill s on (st.Code = s.StaffCode) and (t.Code =
s.SkillCode)
where (t.ParentCode = 391) and (t.DescriptionLong like 'TRM%') and
(st.FullName like 'A%')
order by st.FullName,st.Code, t.DescriptionLong,t.Code;

When I use DBSYS V3.30 to perform this it runs flawlessly.  However, when I
run via an application using DBISAM 3.21 through ReportBuilder I get the
following message:

DBISAM Engine Error #  11949 'Internal join error - table correlation name s
is target of multiple join conditions in WHERE or JOIN clause'

My question is, is it possible that this limitation was removed between
V3.21 and 3.30, or could it be a ReportBuilder limitation (I am creating the
SQL statement directly rather than through wizards)?

Help appreciated

Alex

Alex,

<< My question is, is it possible that this limitation was removed between
V3.21 and 3.30, >>

Most definitely.  There were a few join issues like this that were corrected
in 3.22 and higher:

http://www.elevatesoft.com/scripts/incident.dll?action=search&category=dbisam

Search on "join".

--
Tim Young
Elevate Software
www.elevatesoft.com