[CLOSED] Can you perform a select query against the Dataset?

[Venus]

I have 2 tables in my dataset and want to create a select statement against the two tables with a join, creating yet a third table in my dataset. The key here, I want to do it AGAINST the cached Dataset and NOT the server.

I want the user to play with the numbers and see the results on the screen and when they're happy THEN they click save and the data goes to the server. I know how to do this in a function that loops record by record I was hoping I could just do a select on the two tables in the dataset and storing the results in a third. Can you do a select & join against a Dataset?

Thanks