select baz.id, foo.name
    from foo,                    -- regular table
    ( 
       select id, frob from bar
    ) baz                        -- a sub-select

    where foo.id = baz.frob      -- something that joins the two