Error:CANNOT REPEAT TABLE NAME IN FROM CLAUSE

This SQL works: (using SQL VIEW)

Please Login or Register  to view this content.

====================
The error msg is
CANNOT REPEAT TABLE NAME IN FROM CLAUSE
====================
Can anyone fix the 2nd SQL STATEMENT

Thanks

regards
John