USE Mall
GO

SET NOCOUNT ON

--********** 左连接 **********--
--********** Begin **********--
SELECT p.prod_id, p.prod_name, p.prod_price, p.vend_id,
       v.vend_id, v.vend_name, v.vend_phone
FROM Products p LEFT JOIN Vendors v
ON p.vend_id = v.vend_id;
--********** End **********--

--********** 右连接 **********--
--********** Begin **********--
SELECT p.prod_id, p.prod_name, p.prod_price, p.vend_id,
       v.vend_id, v.vend_name, v.vend_phone
FROM Products p RIGHT JOIN Vendors v
ON p.vend_id = v.vend_id;
--********** End **********--

GO