Long JOINS Returns No result all tables have one to many relationship with a particular table

I have a Table Enterpries with Primary Key 'RCNO'. All other tables have a one to many relationship with Enterprise via it's RCNO column. I make a Join of all the tables and i get nothing. Below is the query. I would like to attach the tables(sql). I can't find a place to upload. SELECT enterprise.RCNO AS enterprise_RCNO, enterprise.ADDRESS AS enterprise_ADDRESS, enterprise.NAME AS enterprise_NAME, enterprise.WEBSITE AS enterprise_WEBSITE, enterpriseinfo.ACCTYEAR AS enterpriseinfo_ACCTYEAR, enterpriseinfo.BASISFORCOMPLETION AS enterpriseinfo_BASISFORCOMPLETION, enterpriseinfo.HASEQUITYINVESTMENTABROAD AS enterpriseinfo_HASEQUITYINVESTMENTABROAD, enterpriseinfo.ISPARTOFGROUP AS enterpriseinfo_ISPARTOFGROUP, enterpriseinfo.NOOFSTAFF AS enterpriseinfo_NOOFSTAFF, foreignenterprises.ENTERPRISENAME AS foreignenterprises_ENTERPRISENAME, nigerianenterprises.ENTERPRISENAME AS nigerianenterprises_ENTERPRISENAME, principalactivityturnover.ACCTYEAR AS principalactivityturnover_ACCTYEAR, principalactivityturnover.AREAOFACTIVITY AS principalactivityturnover_AREAOFACTIVITY, principalactivityturnover.PERCENTAGECONTRIBUTION AS principalactivityturnover_PERCENTAGECONTRIBUTION, bookvalueofshareholderscapital.ACCTYEAR AS bookvalueofshareholderscapital_ACCTYEAR, bookvalueofshareholderscapital.BOOKVALUE AS bookvalueofshareholderscapital_BOOKVALUE, bookvalueofshareholderscapital.COUNTRY AS bookvalueofshareholderscapital_COUNTRY, bookvalueofshareholderscapital.NAME AS bookvalueofshareholderscapital_NAME, bookvalueofshareholderscapital.PERCENTAGEOWNERSHIP AS bookvalueofshareholderscapital_PERCENTAGEOWNERSHIP, bookvalueofshareholderscapital.REVALUATION AS bookvalueofshareholderscapital_REVALUATION, bookvalueofshareholderscapital.SHARESPURCHASED AS bookvalueofshareholderscapital_SHARESPURCHASED, bookvalueofshareholderscapital.SHARESSOLD AS bookvalueofshareholderscapital_SHARESSOLD, inwarddirectinvestment.ACCTYEAR AS inwarddirectinvestment_ACCTYEAR, inwarddirectinvestment.BOOKSHARECAPITAL AS inwarddirectinvestment_BOOKSHARECAPITAL, inwarddirectinvestment.COUNTRY AS inwarddirectinvestment_COUNTRY, inwarddirectinvestment.NAME AS inwarddirectinvestment_NAME, inwarddirectinvestment.PURCHASEDSHAREFROMINVESTOR AS inwarddirectinvestment_PURCHASEDSHAREFROMINVESTOR, inwarddirectinvestment.SALESOFSHARETOINVESTOR AS inwarddirectinvestment_SALESOFSHARETOINVESTOR, inwarddirectinvestment.SHARECAPITALPERCENTAGE AS inwarddirectinvestment_SHARECAPITALPERCENTAGE, inwarddirectinvestmentsubsidiary.ACCTYEAR AS inwarddirectinvestmentsubsidiary_ACCTYEAR, inwarddirectinvestmentsubsidiary.BOOKSHARECAPITAL AS inwarddirectinvestmentsubsidiary_BOOKSHARECAPITAL, inwarddirectinvestmentsubsidiary.COUNTRY AS inwarddirectinvestmentsubsidiary_COUNTRY, inwarddirectinvestmentsubsidiary.NAME AS inwarddirectinvestmentsubsidiary_NAME, inwarddirectinvestmentsubsidiary.PURCHASEDSHAREFROMINVESTOR AS inwarddirectinvestmentsubsidiary_PURCHASEDSHAREFROMINVESTOR, inwarddirectinvestmentsubsidiary.SALESOFSHARETOINVESTOR AS inwarddirectinvestmentsubsidiary_SALESOFSHARETOINVESTOR, inwarddirectinvestmentsubsidiary.SHARECAPITALPERCENTAGE AS inwarddirectinvestmentsubsidiary_SHARECAPITALPERCENTAGE, inwarddirectinvestmentsubsidiaryp.ACCTYEAR AS inwarddirectinvestmentsubsidiaryp_ACCTYEAR, inwarddirectinvestmentsubsidiaryp.BOOKSHARECAPITAL AS inwarddirectinvestmentsubsidiaryp_BOOKSHARECAPITAL, inwarddirectinvestmentsubsidiaryp.COUNTRY AS inwarddirectinvestmentsubsidiaryp_COUNTRY, inwarddirectinvestmentsubsidiaryp.NAME AS inwarddirectinvestmentsubsidiaryp_NAME, inwarddirectinvestmentsubsidiaryp.PURCHASEDSHAREFROMINVESTOR AS inwarddirectinvestmentsubsidiaryp_PURCHASEDSHAREFROMINVESTOR, inwarddirectinvestmentsubsidiaryp.SALESOFSHARETOINVESTOR AS inwarddirectinvestmentsubsidiaryp_SALESOFSHARETOINVESTOR, inwarddirectinvestmentsubsidiaryp.SHARECAPITALPERCENTAGE AS inwarddirectinvestmentsubsidiaryp_SHARECAPITALPERCENTAGE, inwardportfolioinvestmentsubsidiary.ACCTYEAR AS inwardportfolioinvestmentsubsidiary_ACCTYEAR, inwardportfolioinvestmentsubsidiary.COUNTRY AS inwardportfolioinvestmentsubsidiary_COUNTRY, inwardportfolioinvestmentsubsidiary.MARKETVALUE AS inwardportfolioinvestmentsubsidiary_MARKETVALUE, inwardportfolioinvestmentsubsidiary.NAME AS inwardportfolioinvestmentsubsidiary_NAME, inwardportfolioinvestmentsubsidiary.PURCHASEOFSHARES AS inwardportfolioinvestmentsubsidiary_PURCHASEOFSHARES, inwardportfolioinvestmentsubsidiary.SALESOFSHARES AS inwardportfolioinvestmentsubsidiary_SALESOFSHARES, inwardportfolioinvestmentsubsidiary.SHARECAPITALPERCENTAGE AS inwardportfolioinvestmentsubsidiary_SHARECAPITALPERCENTAGE, inwardportfolioinvestmentsubsidiaryp.ACCTYEAR AS inwardportfolioinvestmentsubsidiaryp_ACCTYEAR, inwardportfolioinvestmentsubsidiaryp.COUNTRY AS inwardportfolioinvestmentsubsidiaryp_COUNTRY, inwardportfolioinvestmentsubsidiaryp.MARKETVALUE AS inwardportfolioinvestmentsubsidiaryp_MARKETVALUE, inwardportfolioinvestmentsubsidiaryp.NAME AS inwardportfolioinvestmentsubsidiaryp_NAME, inwardportfolioinvestmentsubsidiaryp.PURCHASEOFSHARES AS inwardportfolioinvestmentsubsidiaryp_PURCHASEOFSHARES, inwardportfolioinvestmentsubsidiaryp.SALESOFSHARES AS inwardportfolioinvestmentsubsidiaryp_SALESOFSHARES, inwardportfolioinvestmentsubsidiaryp.SHARECAPITALPERCENTAGE AS inwardportfolioinvestmentsubsidiaryp_SHARECAPITALPERCENTAGE, externaldebtnonresident.ACCTYEAR AS externaldebtnonresident_ACCTYEAR, externaldebtnonresident.INTERESTPAYABLE AS externaldebtnonresident_INTERESTPAYABLE, externaldebtnonresident.NETTRASACTIONS AS externaldebtnonresident_NETTRASACTIONS, externaldebtnonresident.OTHERCHARGES AS externaldebtnonresident_OTHERCHARGES, externaldebtnonresident.STOCKOFDEBT AS externaldebtnonresident_STOCKOFDEBT, externaldebtnonresidentsubsidiary.ACCTYEAR AS externaldebtnonresidentsubsidiary_ACCTYEAR, externaldebtnonresidentsubsidiary.INTERESTPAYABLE AS externaldebtnonresidentsubsidiary_INTERESTPAYABLE, externaldebtnonresidentsubsidiary.NETTRASACTIONS AS externaldebtnonresidentsubsidiary_NETTRASACTIONS, externaldebtnonresidentsubsidiary.OTHERCHARGES AS externaldebtnonresidentsubsidiary_OTHERCHARGES, externaldebtnonresidentsubsidiary.STOCKOFDEBT AS externaldebtnonresidentsubsidiary_STOCKOFDEBT, externaldebtnonresidentsubsidiaryp.ACCTYEAR AS externaldebtnonresidentsubsidiaryp_ACCTYEAR, externaldebtnonresidentsubsidiaryp.INTERESTPAYABLE AS externaldebtnonresidentsubsidiaryp_INTERESTPAYABLE, externaldebtnonresidentsubsidiaryp.NETTRASACTIONS AS externaldebtnonresidentsubsidiaryp_NETTRASACTIONS, externaldebtnonresidentsubsidiaryp.OTHERCHARGES AS externaldebtnonresidentsubsidiaryp_OTHERCHARGES, externaldebtnonresidentsubsidiaryp.STOCKOFDEBT AS externaldebtnonresidentsubsidiaryp_STOCKOFDEBT, externaldebtunrelated.ACCTYEAR AS externaldebtunrelated_ACCTYEAR, externaldebtunrelated.CLOSINGBALANCE AS externaldebtunrelated_CLOSINGBALANCE, externaldebtunrelated.DEBTINSTRUMENT AS externaldebtunrelated_DEBTINSTRUMENT, externaldebtunrelated.RECIEPTS AS externaldebtunrelated_RECIEPTS, externaldebtunrelated.REPAYMENTS AS externaldebtunrelated_REPAYMENTS, externaldebtunrelated.REVALUATIONS AS externaldebtunrelated_REVALUATIONS, externaldebtunrelated.INTERESTPAYABLE AS externaldebtunrelated_INTERESTPAYABLE, externaldebtliabilitiescountry.ACCTYEAR AS externaldebtliabilitiescountry_ACCTYEAR, externaldebtliabilitiescountry.COUNTRY AS externaldebtliabilitiescountry_COUNTRY, externaldebtliabilitiescountry.DEBTAMOUNT AS externaldebtliabilitiescountry_DEBTAMOUNT, externaldebtliabilitiescountry.DEBTINSTRUMENT AS externaldebtliabilitiescountry_DEBTINSTRUMENT, otherincomefromnonresidents.ACCTYEAR AS otherincomefromnonresidents_ACCTYEAR, otherincomefromnonresidents.INCOMEITEM AS otherincomefromnonresidents_INCOMEITEM, otherincomefromnonresidents.INCOMEVALUE AS otherincomefromnonresidents_INCOMEVALUE, shareholderscapitalofsubsidiary.ACCTYEAR AS shareholderscapitalofsubsidiary_ACCTYEAR, shareholderscapitalofsubsidiary.BOOKVALUEOFSHAREHOLDERS AS shareholderscapitalofsubsidiary_BOOKVALUEOFSHAREHOLDERS, shareholderscapitalofsubsidiary.CHANGEINPAIDUPSHARECAPITAL AS shareholderscapitalofsubsidiary_CHANGEINPAIDUPSHARECAPITAL, shareholderscapitalofsubsidiary.CHANGEINRETAINEDEARNING AS shareholderscapitalofsubsidiary_CHANGEINRETAINEDEARNING, shareholderscapitalofsubsidiary.COUNTRY AS shareholderscapitalofsubsidiary_COUNTRY, shareholderscapitalofsubsidiary.NAME AS shareholderscapitalofsubsidiary_NAME, shareholderscapitalofsubsidiary.REVALUATION AS shareholderscapitalofsubsidiary_REVALUATION, enterpriseinvestments.ACCTYEAR AS enterpriseinvestments_ACCTYEAR, enterpriseinvestments.INVESTMENTAMOUNT AS enterpriseinvestments_INVESTMENTAMOUNT, enterpriseinvestments.INVESTMENTITEM AS enterpriseinvestments_INVESTMENTITEM, subsidiaryincomeaccount.ACCTYEAR AS subsidiaryincomeaccount_ACCTYEAR, subsidiaryincomeaccount.DIVIDENSANDPROFITSPAID AS subsidiaryincomeaccount_DIVIDENSANDPROFITSPAID, subsidiaryincomeaccount.ENTERPRISENAME AS subsidiaryincomeaccount_ENTERPRISENAME, subsidiaryincomeaccount.NETINCOMEAFTERTAX AS subsidiaryincomeaccount_NETINCOMEAFTERTAX, subsidiaryincomeaccount.RETAINEDEARNING AS subsidiaryincomeaccount_RETAINEDEARNING, equityclaimsofparent.COUNTRY AS equityclaimsofparent_COUNTRY, equityclaimsofparent.EQUITYVALUEHELD AS equityclaimsofparent_EQUITYVALUEHELD, equityclaimsofparent.NAME AS equityclaimsofparent_NAME, equityclaimsofparent.NETPURCHASES AS equityclaimsofparent_NETPURCHASES, equityclaimsofparent.NETSALES AS equityclaimsofparent_NETSALES, equityclaimsofparent.OTHERCHARGESREVALUATION AS equityclaimsofparent_OTHERCHARGESREVALUATION, equityclaimsofparent.PERCENTAGESHARES AS equityclaimsofparent_PERCENTAGESHARES, equityclaimsofparent.ACCTYEAR AS equityclaimsofparent_ACCTYEAR, equityclaimsofparentsub.COUNTRY AS equityclaimsofparentsub_COUNTRY, equityclaimsofparentsub.EQUITYVALUEHELD AS equityclaimsofparentsub_EQUITYVALUEHELD, equityclaimsofparentsub.NAME AS equityclaimsofparentsub_NAME, equityclaimsofparentsub.NETPURCHASES AS equityclaimsofparentsub_NETPURCHASES, equityclaimsofparentsub.NETSALES AS equityclaimsofparentsub_NETSALES, equityclaimsofparentsub.OTHERCHARGESREVALUATION AS equityclaimsofparentsub_OTHERCHARGESREVALUATION, equityclaimsofparentsub.PERCENTAGESHARES AS equityclaimsofparentsub_PERCENTAGESHARES, equityclaimsofparentsub.ACCTYEAR AS equityclaimsofparentsub_ACCTYEAR, equityclaimsofparentsubp.COUNTRY AS equityclaimsofparentsubp_COUNTRY, equityclaimsofparentsubp.EQUITYVALUEHELD AS equityclaimsofparentsubp_EQUITYVALUEHELD, equityclaimsofparentsubp.NAME AS equityclaimsofparentsubp_NAME, equityclaimsofparentsubp.NETPURCHASES AS equityclaimsofparentsubp_NETPURCHASES, equityclaimsofparentsubp.NETSALES AS equityclaimsofparentsubp_NETSALES, equityclaimsofparentsubp.OTHERCHARGESREVALUATION AS equityclaimsofparentsubp_OTHERCHARGESREVALUATION, equityclaimsofparentsubp.PERCENTAGESHARES AS equityclaimsofparentsubp_PERCENTAGESHARES, equityclaimsofparentsubp.ACCTYEAR AS equityclaimsofparentsubp_ACCTYEAR, externallendingtosubsidiary.ACCTYEAR AS externallendingtosubsidiary_ACCTYEAR, externallendingtosubsidiary.AGGOFEXTERNALLENDING AS externallendingtosubsidiary_AGGOFEXTERNALLENDING, externallendingtosubsidiary.ENTITYNAME AS externallendingtosubsidiary_ENTITYNAME, externallendingtosubsidiary.INTERESTRECIEVABLE AS externallendingtosubsidiary_INTERESTRECIEVABLE, externallendingtosubsidiary.NETLENDING AS externallendingtosubsidiary_NETLENDING, externallendingtosubsidiary.OTHERCHANGESANDREVALUATION AS externallendingtosubsidiary_OTHERCHANGESANDREVALUATION, externallendingrelatedparent.ACCTYEAR AS externallendingrelatedparent_ACCTYEAR, externallendingrelatedparent.AGGEXTERNALLENDING AS externallendingrelatedparent_AGGEXTERNALLENDING, externallendingrelatedparent.INTERESTRECIEVABLE AS externallendingrelatedparent_INTERESTRECIEVABLE, externallendingrelatedparent.NETLENDING AS externallendingrelatedparent_NETLENDING, externallendingrelatedparent.REVALUATIONS AS externallendingrelatedparent_REVALUATIONS, externallendingrelatedsubparent.ACCTYEAR AS externallendingrelatedsubparent_ACCTYEAR, externallendingrelatedsubparent.AGGEXTERNALLENDING AS externallendingrelatedsubparent_AGGEXTERNALLENDING, externallendingrelatedsubparent.INTERESTRECIEVABLE AS externallendingrelatedsubparent_INTERESTRECIEVABLE, externallendingrelatedsubparent.NETLENDING AS externallendingrelatedsubparent_NETLENDING, externallendingrelatedsubparent.REVALUATIONS AS externallendingrelatedsubparent_REVALUATIONS, debtinstrumentsheldunrelated.ACCTYEAR AS debtinstrumentsheldunrelated_ACCTYEAR, debtinstrumentsheldunrelated.CLOSINGBALANCE AS debtinstrumentsheldunrelated_CLOSINGBALANCE, debtinstrumentsheldunrelated.DEBTINSTRUMENT AS debtinstrumentsheldunrelated_DEBTINSTRUMENT, debtinstrumentsheldunrelated.INTERESTRECIEVABLE AS debtinstrumentsheldunrelated_INTERESTRECIEVABLE, debtinstrumentsheldunrelated.OPENINGBALANCE AS debtinstrumentsheldunrelated_OPENINGBALANCE, debtinstrumentsheldunrelated.PRINCIPALREPAYMENT AS debtinstrumentsheldunrelated_PRINCIPALREPAYMENT, debtinstrumentsheldunrelated.PURCHASE AS debtinstrumentsheldunrelated_PURCHASE, debtinstrumentsheldunrelated.REVALUATION AS debtinstrumentsheldunrelated_REVALUATION, debtinstrumenturcountry.ACCTYEAR AS debtinstrumenturcountry_ACCTYEAR, debtinstrumenturcountry.DEBTAMOUNT AS debtinstrumenturcountry_DEBTAMOUNT, debtinstrumenturcountry.DEBTINSTRUMENT AS debtinstrumenturcountry_DEBTINSTRUMENT, debtinstrumenturcountry.DEBTORCOUNTRY AS debtinstrumenturcountry_DEBTORCOUNTRY, otherexpenditurenr.ACCTYEAR AS otherexpenditurenr_ACCTYEAR, otherexpenditurenr.EXPENSEITEM AS otherexpenditurenr_EXPENSEITEM, otherexpenditurenr.EXPENSEVALUE AS otherexpenditurenr_EXPENSEVALUE, depositwithnonresidentbanks.ACCTYEAR AS depositwithnonresidentbanks_ACCTYEAR, depositwithnonresidentbanks.BANKNAME AS depositwithnonresidentbanks_BANKNAME, depositwithnonresidentbanks.CHANGESDUETOEXCHANGE AS depositwithnonresidentbanks_CHANGESDUETOEXCHANGE, depositwithnonresidentbanks.CURRENTOUTSTANDINGBALANCE AS depositwithnonresidentbanks_CURRENTOUTSTANDINGBALANCE, depositwithnonresidentbanks.TRANSACTIONSTHISYEAR AS depositwithnonresidentbanks_TRANSACTIONSTHISYEAR, finderivativecontractwithnr.ACCTYEAR AS finderivativecontractwithnr_ACCTYEAR, finderivativecontractwithnr.CASHRECIEPTSANDDERIVATIVEPAYMENT AS finderivativecontractwithnr_CASHRECIEPTSANDDERIVATIVEPAYMENT, finderivativecontractwithnr.NONRESIDENTNAME AS finderivativecontractwithnr_NONRESIDENTNAME, finderivativecontractwithnr.OUTSTANDINGMARKETPOSITION AS finderivativecontractwithnr_OUTSTANDINGMARKETPOSITION, foriegngovtdebtsecuritycountry.ACCTYEAR AS foriegngovtdebtsecuritycountry_ACCTYEAR, foriegngovtdebtsecuritycountry.CHANGESINVALUEDUETOEXCHANGE AS foriegngovtdebtsecuritycountry_CHANGESINVALUEDUETOEXCHANGE, foriegngovtdebtsecuritycountry.INTERESTRECIEVABLE AS foriegngovtdebtsecuritycountry_INTERESTRECIEVABLE, foriegngovtdebtsecuritycountry.NAME AS foriegngovtdebtsecuritycountry_NAME, foriegngovtdebtsecuritycountry.OTHERCHANGESINCLUDINGREVALUATION AS foriegngovtdebtsecuritycountry_OTHERCHANGESINCLUDINGREVALUATION, foriegngovtdebtsecuritycountry.OUTSTANDINGMARKETVALUE AS foriegngovtdebtsecuritycountry_OUTSTANDINGMARKETVALUE, dividendearningsprofit.ACCTYEAR AS dividendearningsprofit_ACCTYEAR, dividendearningsprofit.DIVIDENDSPAID AS dividendearningsprofit_DIVIDENDSPAID, dividendearningsprofit.INTERESTPAID AS dividendearningsprofit_INTERESTPAID, dividendearningsprofit.INTERESTRECIEVED AS dividendearningsprofit_INTERESTRECIEVED, dividendearningsprofit.NETINCOMEAFTERTAX AS dividendearningsprofit_NETINCOMEAFTERTAX, dividendearningsprofit.REALISEDHOLDINGS AS dividendearningsprofit_REALISEDHOLDINGS, dividendearningsprofit.RETAINEDEARNING AS dividendearningsprofit_RETAINEDEARNING FROM enterprise enterprise INNER JOIN enterpriseinfo enterpriseinfo ON enterprise.RCNO = enterpriseinfo.RCNO INNER JOIN foreignenterprises foreignenterprises ON enterprise.RCNO = foreignenterprises.RCNO INNER JOIN nigerianenterprises nigerianenterprises ON enterprise.RCNO = nigerianenterprises.RCNO INNER JOIN principalactivityturnover principalactivityturnover ON enterprise.RCNO = principalactivityturnover.RCNO INNER JOIN bookvalueofshareholderscapital bookvalueofshareholderscapital ON enterprise.RCNO = bookvalueofshareholderscapital.RCNO INNER JOIN inwarddirectinvestment inwarddirectinvestment ON enterprise.RCNO = inwarddirectinvestment.RCNO INNER JOIN inwarddirectinvestmentsubsidiary inwarddirectinvestmentsubsidiary ON enterprise.RCNO = inwarddirectinvestmentsubsidiary.RCNO INNER JOIN inwarddirectinvestmentsubsidiaryp inwarddirectinvestmentsubsidiaryp ON enterprise.RCNO = inwarddirectinvestmentsubsidiaryp.RCNO INNER JOIN inwardportfolioinvestmentsubsidiary inwardportfolioinvestmentsubsidiary ON enterprise.RCNO = inwardportfolioinvestmentsubsidiary.RCNO INNER JOIN inwardportfolioinvestmentsubsidiaryp inwardportfolioinvestmentsubsidiaryp ON enterprise.RCNO = inwardportfolioinvestmentsubsidiaryp.RCNO INNER JOIN externaldebtnonresident externaldebtnonresident ON enterprise.RCNO = externaldebtnonresident.RCNO INNER JOIN externaldebtnonresidentsubsidiary externaldebtnonresidentsubsidiary ON enterprise.RCNO = externaldebtnonresidentsubsidiary.RCNO INNER JOIN externaldebtnonresidentsubsidiaryp externaldebtnonresidentsubsidiaryp ON enterprise.RCNO = externaldebtnonresidentsubsidiaryp.RCNO INNER JOIN externaldebtunrelated externaldebtunrelated ON enterprise.RCNO = externaldebtunrelated.RCNO INNER JOIN externaldebtliabilitiescountry externaldebtliabilitiescountry ON enterprise.RCNO = externaldebtliabilitiescountry.RCNO INNER JOIN otherincomefromnonresidents otherincomefromnonresidents ON enterprise.RCNO = otherincomefromnonresidents.RCNO INNER JOIN shareholderscapitalofsubsidiary shareholderscapitalofsubsidiary ON enterprise.RCNO = shareholderscapitalofsubsidiary.RCNO INNER JOIN enterpriseinvestments enterpriseinvestments ON enterprise.RCNO = enterpriseinvestments.RCNO INNER JOIN subsidiaryincomeaccount subsidiaryincomeaccount ON enterprise.RCNO = subsidiaryincomeaccount.RCNO INNER JOIN equityclaimsofparent equityclaimsofparent ON enterprise.RCNO = equityclaimsofparent.RCNO INNER JOIN equityclaimsofparentsub equityclaimsofparentsub ON enterprise.RCNO = equityclaimsofparentsub.RCNO INNER JOIN equityclaimsofparentsubp equityclaimsofparentsubp ON enterprise.RCNO = equityclaimsofparentsubp.RCNO INNER JOIN externallendingtosubsidiary externallendingtosubsidiary ON enterprise.RCNO = externallendingtosubsidiary.RCNO INNER JOIN externallendingrelatedparent externallendingrelatedparent ON enterprise.RCNO = externallendingrelatedparent.RCNO INNER JOIN externallendingrelatedsubparent externallendingrelatedsubparent ON enterprise.RCNO = externallendingrelatedsubparent.RCNO INNER JOIN debtinstrumentsheldunrelated debtinstrumentsheldunrelated ON enterprise.RCNO = debtinstrumentsheldunrelated.RCNO INNER JOIN debtinstrumenturcountry debtinstrumenturcountry ON enterprise.RCNO = debtinstrumenturcountry.RCNO INNER JOIN otherexpenditurenr otherexpenditurenr ON enterprise.RCNO = otherexpenditurenr.RCNO INNER JOIN depositwithnonresidentbanks depositwithnonresidentbanks ON enterprise.RCNO = depositwithnonresidentbanks.RCNO INNER JOIN finderivativecontractwithnr finderivativecontractwithnr ON enterprise.RCNO = finderivativecontractwithnr.RCNO INNER JOIN foriegngovtdebtsecuritycountry foriegngovtdebtsecuritycountry ON enterprise.RCNO = foriegngovtdebtsecuritycountry.RCNO, dividendearningsprofit dividendearningsprofit WHERE enterprise.RCNO = 'RC 10000'