SQL HELP (Searching for multiple things in the same column)

[treppers]

Ok... My problem might be simple but I have no idea how to go about doing it!

I have a table with two columns... One is for Vendor ID's and the other is for Machine Numbers... I need an SQL string that will allow me to search for multiple Machine Numbers that match a single Vendor ID... I can't use "Where machineNum = 'example' And machineNum = 'example2';" Because the numbers are on different rows!!! (I hope that makes sence...) Here is a visual example....

VendorID

1
1
1
2
3

MachineNum
2
3
5
3
5

I need to be able to search for all vendorID's that have MachineNumbers 2, 3, and 5.... So in this example I would get an output of VendorID = 1...
😕

Thanks
Travis

[stolzyboy]

select VendorID where MachineNum = 3

that would give you VendorID 1 and 2

or you aren't explaining it good enough for me to understand

[treppers]

Originally posted by stolzyboy
select VendorID where MachineNum = 3

that would give you VendorID 1 and 2

or you aren't explaining it good enough for me to understand

Thats true it would give me VendorID 1 and 2 but as the bottom of my message states, I need the output to give me VendorID 1 because ID 1 is the only one that has ALL THREE Machine numbers I'm searching for....

I'm sorry if my post is confusing...

But I need to be able to search for Multiple Machine Numbers and get only the VendorID that maches all of them...

Thanks So Much....