Medicinal cannabis helps relieve cancer pain and can complement other painkilling drugs, research has suggested.