accept e_vidid prompt 'Enter the video id for the video that you want to contact the supplier about:'




select name, phone from supplier, video where supplier.sid=video.sid and video.vid='&e_vidid';