Constructing a singleton query from a relational data source



I can't seem to do the following (in pseudo code)

select prediction of an attribute
from a data mining model
natural prediction join
(SELECT(
OPENQUERY(source, some select)
) as nested table
) as t

instead I need to manually build up the singleton parameters in a bunch of union'd selects.

Am I missing something?
.