How to create advanced DataAssist query
I am trying to create a query using an advanced data table query. My query is already created and used INNER JOIN and other nested SELECT statements. When trying to use the Data Assist Search Wizard it allows me to enter my own query but I cannot get it to give a result set based on the query. When I use the Data Assist Wizard I can only do simple queries on single tables. Both of these are not acceptable answers. I need to do complex queries on both. At a minimum I need to do multiple table queries.