You must have previous experience writing SQL queries to use this feature of the accounting and reporting console.
Click New Advanced Query on the Query List screen.
Enter your SQL query in the text box.
This is the only difference compared to the actions available for the Simple Query.
Save or run your query.
You can run an advances query that you just created. You can also run an advanced query that you previously saved.
To run a query that you just created, click Run on the Advanced Query screen.
To run a query that you previously saved, select the query from the Query List screen, and then click Run.