RE: SQL Question

I forgot to give you my "solution," but the prior questions should be
considered.

Select j.jobnumber
from mytable j
Where j.partnumber = selection1
Join mytable k on j.jobnumber=k.jobnumber and k.partnumber=selection2
Join mytable l on j.jobnumber=l.jobnumber and l.partnumber=selection3

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If living conditions don't stop improving in this country, we're going to
run out of humble beginnings for our great men."
-- Russell P. Askue

I have a data file:

JobNumber PartNumber

A1 123

A1 456

A1 111

B1 123

B1 789

C1 123

C1 456

C1 789



The user will enter 3 part numbers; 123, 456, 789... and I need the
results of my SQL select to return C1. Is this possible? If so, can
someone provide a "code snippet"