i think it is valid syntax, its just giving a cross join because there isn't a join in the WHERE clause.

select

*

from

table1 t1

,(select ...) t2

where

t1.col1 = t2.col1

jasons example is a good modification, though. i would go with his update.