OLE DB Source SQL:

Select customer_key From customer (nolock)

customer_key

-------------

10001

Lookup SQL:

Select customer_key, phone_type, phone_number

From phone (nolock) as ph Join customer (nolock) as c

On ph.customer_key = c.customer_key

customer_key phone_type ...

Thanks for your reply! But that will not solve my problem because in my main SQL I have only one record whereas in lookup SQL I have 3 records for...