今天在学习SQL的过程中,写了一个内连接的SQL语句,一直报错
“check the manual that corresponds to your MySQL server version for the right syntax to use near ”
后来发现select后面多加了一个逗号,去掉后就可以正常运行了。
内联接查询:
select (字段1,字段2,字段3)
from 关联表1 inner join 关联表2
on 关联表1.关联字段 = 关联表2.关联字段
例如:
SELECT prod_name , vend_name , vend_address , prod_price , prod_desc
FROM vendors INNER JOIN products
ON vendors.vend_id
= products.vend_id
联结多个表:
select (字段1,字段2,字段3)
from 关联表1 , 关联表2,关联表3
where 关联表1.关联字段 = 关联表2.关联字段
and 关联表1.关联字段 = 关联表3.关联字段
and 字段名 = 值
例如:
SELECT prod_name , vend_name , vend_address , prod_price , prod_desc
FROM vendors , products , orderitems
WHERE vendors.vend_id
= products.vend_id
AND orderitems.prod_id
= products.prod_id
AND order_num = 20005