• Your attached query has a similar problem. The optional FROM clause in a SELECT statement is the same as in a DELETE statement.

    1) The FROM keyword is required

    2) The object is required

    3) The alias is optional

    Your EXISTS subquery is missing the required object in the FROM clause. You can easily fix this by moving your derived table x to the EXISTS subquery.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA