An SQL Query

Hello. I'm trying to extract three sets of values for each of the
emission lines I am searching for, so my question is simply this:

How do I make an SQL query that will only return results where all
three emission lines are shown?

I'm using the LineID currently to identify the lines at present in my
SQL query:

SELECT TOP 100
SpecObjID, LineID, RestWave, EW, Continuum

FROM
SpecLine

WHERE
LineID = 5008 OR LineID = 3727 OR LineID = 4863


Kind Regards,

Matt