Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Could this be a version difference? |
Sat, Apr 14 2007 2:50 AM | Permanent Link |
"Al Vas" | 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 |
Sat, Apr 14 2007 3:56 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |