It is a move learned by the following Pokemon through TM29 in Emerald:
* Gengar
* Haunter
* Gastly
Keep in mind that you can also teach this move to any Pokemon that can learn it via TM29 through the move tutor in the Battle Frontier.