SQL Error in FROM clause: SQL Editor: Encountered B. Was expecting: "of"......

Database
Enthusiast

SQL Error in FROM clause: SQL Editor: Encountered B. Was expecting: "of"......

I am experiencing writers block.  The second join has an error with AS B after the FROM clause:

FROM

Posting text removed based on formal request from Owner of the associated Intelectual Property.

The row with the error is highlighted in yellow.  I am not sure what I am missing in the code to correct the error. Any help will be greatly appreciated!

2 REPLIES
Junior Contributor

Re: SQL Error in FROM clause: SQL Editor: Encountered B. Was expecting: "of"......

Well, there's no alias after the Derived Table, no ON and no JOIN to B:

Posting text removed based on formal request from Owner of the associated Intelectual Property.

Dieter
Enthusiast

Re: SQL Error in FROM clause: SQL Editor: Encountered B. Was expecting: "of"......

Thanks for your help!