Hi Trent,
Unfortunately, I have been unable to join to other datasets using the metadata trick. However, if you are interested in joining on a certain set of values, you could select them in javascript using a separate statement and then run a second query to return the data that you are actually interested in. I hope that this option works for your purposes.

Greg