Spectroscopy of faint radio sources: the nature of the sub-mJy radio-source population