Thanks for your help... looks like I'll have to add TRIM.
My DB admin is on vacation so i have to do this solo [thumbsdown].
If anyone has any ideas i'd love to hear them
Sincerely,
Mohamed
Thank-you for the prompt reply.
I should have posted the query that i had come up with in my original post because that is the same one :-)... I guess what i want to know is if there is another way that might be faster because this query ran for well over a day before it crashed!
Thank-you...
Hello All,
I have a table of ~5,000,000 records (ID, name, title) and a second table of ~2,000,000 records (ID, name, title).
What i need to do is return the ID's from the first table where there is no exact match with a name/title in the second table. So if a row in table 1 is (3, Tom...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.