title: At most one record can be returned by this subquery. (Error 3354)
body: <p>Hi my query getting this error help me to recover it</p>
  
  <pre><code>SELECT CompanyId, CompanyName, RegistrationNumber,
    (select CompanyAddress from RPT_Company_Address where 
     RPT_Company_Address.CompanyId=Company.CompanyId) AS CompanyAddress, 
    MobileNumber, FaxNumber, CompanyEmail, CompanyWebsite, VatTinNumber
  FROM Company;`
  </code></pre>