title: ACUMATICA BQL QUERIES
body: <p>I need to return records from the database using BQL. I have tried writing the BQL query like this
  <code>TaxZone zone = PXSelectJoin&lt;TaxZone, InnerJoin&lt;LocationExtAddress, On&lt;TaxZone.taxZoneID, Equal&lt;LocationExtAddress.cTaxZoneID&gt;&gt;, InnerJoin&lt;Customer, On&lt;Customer.bAccountID, Equal&lt;LocationExtAddress.bAccountID&gt;&gt;, Where&lt;Customer.bAccountID, Equal&lt;Current&lt;Customer.BAccountID&gt;&gt;&gt;;</code>
  and I get errors</p>
  
  <pre><code>\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term '&lt;'
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
  </code></pre>
  
  <p>I have also tried using one DAC like this
  <code>Customer cust = PXSelect&lt;Customer, Where&lt;Customer.bAccountID, Equal&lt;Current&lt;Customer.bAccountID&gt;&gt;&gt;;</code>
  I am still getting the error</p>
  
  <pre><code>\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term '&lt;'
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term ','
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term '&gt;'
  \App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
  Compiler time, in seconds: 21.1134712
  </code></pre>
  
  <p>Any help on the issue would be really appreciated because I have gone through the documentation, that is the format that is supporsed to be written</p>