Specify SQL query not working

[deepak]

@tmayfield

where PartNum like “MEG%” or PartNum like “MEP%” or PartNum like “MESS%”
and PartNum <> “Messer”
and PartNum <> “messer parts”
and PartNum <> “messer rigging”
and PartNum <> “messer consumables”
and PartNum <> “messer nozzle”

Can you share the entire SQL instead of just the sub query ? Clearly you are missing a join.