Database Software

I would like to run a select statement for a what if analysis where I join two tables by a column. How do I run a sql statement where one table I would like query from the LIVE version vs the other table where I'd like to query from a different workspace?

Or in other words, I want to run this SQL query where I want to use different gotodate for the two tables? It appears to me this is a standard use case of a what if analysis, and could be achieved in workspaces. But then for every scenario, I need to create a new workspace. Is there an easier way to achieve this if I have to run many scenarios at the same time?

TableA: id 456 version 5 ---- table B: id: 456 version 40
TableA: id 456 version 5 ---- table B: id: 456 version 45
TableA: id 456 version 5 ---- table B: id: 456 version 55
TableA: id 456 version 5 ---- table B: id: 456 version 66
....
....

Thank you in advance.

Edited by: 967018 on Oct 23, 2012 11:31 AM