Modifying SQL Statement In A Lookup

Hi there,

I'm trying to modify the SQL statement of a Lookup Transformation.

In my DataSet I have 2 columns A, B - I join against a table on columns A and B by

But I only want to match on column B - where column A doesn't match. (I'm looking for duplicate values of B)

So I've tried modifying the SQL statement to:

select * from
(select * from [dbo].[LookupTable]) as refTable
where [refTable].[ColumnB] = ? and [refTable].[ColumnA] <> ?

(The paremeter mapping takes care of itself).

Anyway, it seems sometimes I'm returning rows where it HAS matched on ColumnA.

I'm I on the right track here?



Cheers,

dave.