SQL search three table columns for three variable
Posted on 2013-06-12
I have a situation where I have three table columns, we will call them Part1, Part2, and Part3.
A user will input three part numbers into a program and I will need to search for that combination of part numbers but the part numbers could be in any order and exist in any one of those columns listed above. all three of the parts entered by the user must exist in the three DB columns to be true and they can not be repeated unless the user enters the same part number twice. Is there any way to perform a search for this in SQL?
I understand this may be kind of vague so please ask questions if you have any.