Previse Inner Join-a?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
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)
(Object)#0
message = "faultCode:INVALID_AMF_MESSAGE faultString:'Invalid AMF message' faultDetail:''"
name = "Error"
rootCause = (null)
Unapred hvala,
Daniel Dulic
--
With The Best Regards,
Daniel Dulić, Web System Development
http://www.citysuteam.com
Telefon: +381 (0) 64 / 364 - 65 - 91
E-Mail: [email protected]
CitySu team, Web Services Company
Antona Aškerca 44/50,
24000 Subotica
CitySu team
Re: Previse Inner Join-a?