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')