Re: Subqueries using the same source table

[Brian Caruso]

You will have to rewrite statements to use joins or to not use subqueries with the same table:

SELECT dataID FROM data WHERE data.Name NOT LIKE '???'
AND dataID IN
(SELECT dataID FROM data WHERE data.Class LIKE 'arm' OR data.Class LIKE 'hand' OR data.Class LIKE 'fist' )

becomes:

SELECT dataID FROM data WHERE data.Name NOT LIKE '???'
AND (data.Class LIKE 'arm' OR data.Class LIKE 'hand' OR data.Class LIKE 'fist')