• Hi Lynn

    Yeah very close to the expected result but the RefTable has a primary key on it. so if it encounters a duplicate record from the other table it also tries to insert that

    the table that I am going to be querying may have duplicate values init

    eg

    INSERT INTO BigTable

    VALUES

    ('Microsoft Office 2003'),

    ('Microsoft 2003 Office'),

    ('Microsoft Office 2003 Professional'),

    ('Sun Microsystems'),

    ('Sun Microsystems'),

    ('Test'),

    ('Test'),

    ('Test')