注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
题目: use SQL to create a new table that contains all unique values of Make and Type from cert.cars, and Rebate from cert.rebate. For Rebate, show Make and Type if matching; if no matching Make and Type, show missing. Only three variable: Make, Type, Rebate.
.--
个人理解这个是用right join。有大侠可以指点一二吗?以下CODE对吗
Proc sql;
Create table cert.car as.google и
Select cars.make, cars.type, rebate.rebate
From cert.cars right join cert.rebate
On cars.make=rebate.make and cars.type=rebate.type
Quit;
|