Database: Sybase Advantage 11

On my quest to normalize data, I am trying to delete the results I get from this `SELECT` statement:

    SELECT tableA.entitynum
    FROM tableA q
    INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) 
    OR q.memotext NOT LIKE &#39;%/%/%&#39;)
    AND (u.FldFormat = &#39;Date&#39;)
    ;

This is the `DELETE` statement I have come up with:

    DELETE FROM tableA
    WHERE (SELECT q.entitynum
    FROM tableA q
    INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) 
    OR q.memotext NOT LIKE &#39;%/%/%&#39;)
    AND (u.FldFormat = &#39;Date&#39;))
    ;

I continuously get this error when I try to run this statement:

    ERROR IN SCRIPT: poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError = 2124;
    [iAnywhere Solutions][Advantage SQL Engine]Invalid operand for operator: = Boolean value
    cannot be operated with non-Boolean value.

I have also tried this statement:

    DELETE FROM tableA 
    INNER JOIN tableB u on (u.qlabel = tableA.entityrole AND u.fieldnum = tableA.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) 
    OR tableA.memotext NOT LIKE &#39;%/%/%&#39;)
    AND (u.FldFormat = &#39;Date&#39;)
    ;

Which results in:

    ERROR IN SCRIPT: poQuery: Error 7200:  AQE Error:  State = 42000;   NativeError = 2117;
    [iAnywhere Solutions][Advantage SQL Engine] Unexpected token: INNER -- Expecting semicolon.
    -- Location of error in the SQL statement is: 23 (line: 2 column: 1)

Could someone aid me in properly constructing a DELETE query that will result in the proper data being removed? 


All Advantage Database-Server Solutions on Gang of Coders

Total of 1 Advantage Database-Server Solutions

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?