0 - 3 of 3 tags for #derived table

I am experiencing efficiency issues when using derived tables in queries.  I can resolve this by breaking up the existing query into smaller queries but I would like to know technical reasons why derived tables would experience efficiency issues.  Typical format: -

I'm trying to add a field from a different table to a derived query.  This is the first time I have tried to do this.  The query below was working unitl I added the bolded information below.  The error message is as follows:
SELECT Failed.  3707: Syntax error, expected something like ')' between 'soh' and '.'

I'm trying to INSERT INTO a table or CREATE TABLE AS from a SQL statement using the WITH form of a derived table.  Is this possible?