title: Query is too complex error in ms access?
body: <p>I tried to bind 3 queries into single query, using this code but when i click "Datasheet View" it showing error "QUERY IS TOO COMPLEX".</p>
  
  <p>This is my code</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT 
      RPT_Invoice_Less.InvoiceNumber, 
      RPT_Invoice_Less.Terms, 
      RPT_Invoice_Less.Invoicedate, 
      RPT_Invoice_Less.OurQuote, 
      RPT_Invoice_Less.SalesPerson, 
      RPT_Customer.CustomerName, 
      RPT_Customer.CustomerId, 
      RPT_Customer.ContactPerson, 
      RPT_Customer.BillingAddress, 
      RPT_Customer.DeliveryAddress, 
      RPT_Invoice_Less.OrderNumber, 
      RPT_Invoice_Less.ShippingBy, 
      RPT_Invoice_Less.ShipReferenceNo, 
      RPT_Invoice_Less.Notes, 
      RPT_Invoice_Less.Price, 
      RPT_Invoice_Less.Discount, 
      RPT_Invoice_Less.Shipping, 
      RPT_Invoice_Less.Tax, 
      RPT_Invoice_Less.GrandTotal, 
      RPT_Company.CompanyName, 
      RPT_Company.CompanyId, 
      RPT_Company.RegistrationNumber, 
      RPT_Company.Address, 
      RPT_Company.MobileNumber, 
      RPT_Company.FaxNumber, 
      RPT_Company.CompanyEmail, 
      RPT_Company.CompanyWebsite, 
      RPT_Company.VatTinNumber
  FROM 
      (RPT_Invoice_Less 
      INNER JOIN RPT_Customer 
          ON RPT_Invoice_Less.CustomerId=RPT_Customer.CustomerId) 
      INNER JOIN 
      RPT_Company 
          ON RPT_Invoice_Less.CompanyId=RPT_Company.CompanyId;
  </code></pre>