左连接查询三个表.rar

/*CREATE TABLE jobs ( job_id smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, cityID int, provinceID int, countryID int )*/ /*CREATE TABLE city ( cityID smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, cityName int )*/ /*CREATE TABLE province ( provinceID smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, provinceName int )*/ /* CREATE TABLE country ( countryID smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, countryName int ) */ select userName, cityName, productName,countryName, provinceName from ( select userName, cityName, productName, countryName, provinceID,countryID from ( ( select userName, cityName, productName, countryID,provinceID from jobs as t1 LEFT JOIN city as t2 on t1.cityID = t2.ID ) as a left join country t3 on a.countryID = t3.ID ) ) as b left join province t4 on b.provinceID = t4.ID