You'll often see the first answer that comes close being accepted, even though it's fundamentally flawed and doesn't actually work.
Other times, the best answer is something along the lines of "You're approaching the problem wrong.", such as in "I'm storing customer IDs as a comma separated list in a column. How do I join that to the Customer table?"
Too many people will offer up horribly complicated solutions that technically do what the questioner asked, but the real correct answer is "Normalize your schema."
Other times, the best answer is something along the lines of "You're approaching the problem wrong.", such as in "I'm storing customer IDs as a comma separated list in a column. How do I join that to the Customer table?"
Too many people will offer up horribly complicated solutions that technically do what the questioner asked, but the real correct answer is "Normalize your schema."