Code:
ON *:JOIN:#: {
  if ($nick == [color:red]nicknamehere[/color]) {
    beep
  }
}
This will make mIRC beep (according to your sounds settings) when the nickname joins the room.