[ danield @ 18.04.2011. 17:54 ] @
Postovani, Da li je ogranicen broj INNER JOIN-a? Imam sledeci SQL upit, koji nece da se izvrsi, da li neko ima resenje? Code: SELECT a.*, b.*, c.*, d.*, f.*, g.*, h.*, i.*, j.*, k.*, l.*, lj.*, m.*, n.*, nj.*, o.*, p.*, r.* FROM `loans` AS a INNER JOIN `banks` AS b ON a.bankID = b.bankID INNER JOIN `loanType` AS c ON a.loansType = c.idloanType INNER JOIN `currency` AS d ON a.currency = d.idCurrency INNER JOIN `loans_Repayment` as f ON a.loansID = f.loansID INNER JOIN `loans_nominalInterestRate` as g ON a.loansID = g.loansID INNER JOIN `loans_depositInterestRate` as h ON a.loansID = h.loansID INNER JOIN `loans_methodOfCalculatingAnnuities` as i ON a.loansID = i.loansID INNER JOIN `loans_creditRating` as j ON a.loansID = j.loansID INNER JOIN `loans_annualFeeForAdministrationOfLoans` as k ON a.loansID = k.loansID INNER JOIN `loans_SingleFeeForProcessing` as l ON a.loansID = l.loansID INNER JOIN `loans_costOfAppraisalAndPersonalProperty` as lj ON a.loansID = lj.loansID INNER JOIN `loans_insurancePremiumsOrOther` as m ON a.loansID = m.loansID INNER JOIN `loans_costsOfRegistrationInTheRegister` as n ON a.loansID = n.loansID INNER JOIN `loans_costsOfAcquiringOfLandRegistry` as nj ON a.loansID = nj.loansID INNER JOIN `loans_costOfObtainingCertificatesAndOther` as o ON a.loansID = o.loansID INNER JOIN `loans_costOfCreditBureau` as p ON a.loansID = p.loansID INNER JOIN `loans_otherExpenses` as r ON a.loansID = r.loansID WHERE b.visible=1 AND d.markCurrency = 'EUR' AND a.bankID IN(1,2,3,4,5,6,7,8,9,10) ORDER BY b.bankName ASC Kao rezultat dobijem gresku: Code: (Object)#0 message = "faultCode:INVALID_AMF_MESSAGE faultString:'Invalid AMF message' faultDetail:''" name = "Error" rootCause = (null) Unapred hvala, Daniel Dulic |