WHERE colum1 = (SELECT with multiple results)

Neosword

Hi I have a problem with a WHERE clause, I have to compare a column value to a query that returns multiple results, I also tried to substitute the "=" for "IN" but didn't worked.
Any help would be apreciated: D

Delerna

You could try something like this

Expand|Select|Wrap|Line Numbers

 
SELECT field list

FROM YourTable

join (   SELECT TheMultipleResultField 

          FROM TheRecordSource

          WHERE YourFilterRequirements

) a on column1=TheMultipleResultField

here, the join will filter out the rows that don't have matching
records in the subquery.

ck9663

Be careful with IN, it does not work well with NULL values.

I got some notes about that here

-- CK

WHERE colum1 = (SELECT with multiple results)

Post your reply

Similar topics