有供应商表vendors(vid, vname),其中vid是供应商编号，vname是供应商姓名；产品表products(pid,vid,price),其中pid是产品编号，price是价格；查询产品的供应商名，产品名，产品价格。SQL语句的内容是（ ）。

A. select vname,pname,pricefrom vendors,productsinner join vendors.vid=products.vid
B. select vname,pname,price from vendorsinner join products where vendors.vid=products.vid
C. select vname,pname,price from vendorsinner join products on vendors.vid=products.vid
D. select vname,pname,price from vendors,products