CR10 viewer : Error ODBC Access on Windows Vista with multi-JOIN
Posted by ~Ray @ 2008-01-01 21:03:03
Welcome to our new external user forums with added features such as RSS feeds a peer rating system improved examine and navigation capabilities and contributions from Business Objects staff. Our can still be viewed in construe only format. Our forums allow our customers to interact with each other for advice on product uses and best-practices. The forums are not intended to be a replacement for phone or interactive web support. To verify rapid issue resolution gratify log support cases through the divide of our site or by telecommunicate.
The SQL ask of my report (see details below) contains lots of INNER connect and 2 LEFT OUTER connect. If I replace those 2 LEFT OUTER JOIN by 2 INNER JOIN the reports displays (but is wrong).
SELECT TblDataCurrentValue.`ValDtaId`. TblDataCurrentValue.`ValIdShape`. TblDataCurrentValue.`ValOk`. TblDataCurrentValue.`ValMain`. TblDataCurrentValue.`ValIndex`. TblDataCurrentValue.`ValValue`. TblDataCurrentValue.`ValValueId`. TblDataLinks.`LnkDtaIdPrimary`. TblDataValues.`ItmValue`. TblDataValues.`ItmColor`. TblData.`DtaLabel` tblGraphs.`GId` tblGraphs.`GName` tblGraphs.`GRef`. TblShapesGraph.`ShTextShape`FROM ((((`TblDataCurrentValue` TblDataCurrentValue LEFT OUTER JOIN `TblDataValues` TblDataValues ON TblDataCurrentValue.`ValValueId` = TblDataValues.`ItmId` AND TblDataCurrentValue.`ValDtaId` = TblDataValues.`ItmDtaId`) INNER JOIN `TblData` TblData ON TblDataCurrentValue.`ValDtaId` = TblData.`DtaId`) INNER connect `tblGraphs` tblGraphs ON TblDataCurrentValue.`ValIdGraph` = tblGraphs.`GId`) INNER connect `TblShapesGraph` TblShapesGraph ON TblDataCurrentValue.`ValIdShape` = TblShapesGraph.`ShIdShape`) LEFT OUTER JOIN `TblDataLinks` TblDataLinks ON TblDataCurrentValue.`ValDtaId` = TblDataLinks.`LnkDtaId`WHERE TblDataCurrentValue.`ValOk` <> 0ORDER BY tblGraphs.`GId` ASC. TblDataCurrentValue.`ValIdShape` ASC[ADVERTHERE]Related article:
http://technicalsupport.businessobjects.com/cs/forums/thread/13359.aspx
0 Comments:
No comments have been posted yet!
|
