我有這 3 張桌子。現在我需要使用左連接從設備表中的時區表中顯示時區名稱。我怎樣才能做到這一點？請幫忙
表名：[pbi].[GEOTAB_INFO_GROUPS]
GROUP_ID| GROUP_NAME |LOCATION_ID |IMPORTDATE
b27FA | 55310 | 55310 | 20220328
b282B | 35824 | 35824 | 20220328
b2797 | 55876 | 55876 | 20220328
表名：[adl].[GEOTAB_VEHICLE_INFO_DEVICES]
Id Name SerialNumber ActiveFrom ActiveTo DeviceType DevicePlans VehicleIdentificationNumber LicensePlate LicenseState WorkTime ProductId HardwareId TimeZoneId Group_Id Comment ImportDate ImportTime
b957 09-101-57218 3G 000-000-0000 2017-07-05 23:59:52 2022-01-20 20:24:28 OldGeotab ProPlus 15GGD271991176896 7063-OP PR Standard Hours 0 NULL America/New_York b2A06 NULL 20220330 2022-03-30 7:00:58
表名：[pbi].[Location_Time_Zone]
LocationNumber TimeZone ImportDate ImportTime
301194 Central 20211007 07-10-2021 18:44:57
我正在嘗試這樣但沒有得到正確的結果
select distinct d.Id, g.LOCATION_ID, d.Name, d.SerialNumber, d.ActiveFrom, d.ActiveTo, d.DeviceType, d.DevicePlans, d.VehicleIdentificationNumber, d.LicensePlate, d.LicenseState, d.WorkTime, d.ProductId, d.HardwareId, d.TimeZoneId, tz.TimeZone, d.Groups, d.Comment, d.ImportDate
from [adl].[GEOTAB_VEHICLE_INFO_DEVICES] d
left join [pbi].[GEOTAB_INFO_GROUPS] g
on d.Groups = g.GROUP_ID
left join [pbi].[Location_Time_Zone] tz
on tz.LocationNumber = g.LOCATION_ID
uj5u.com熱心網友回復：
Select d.*, t.TimeZone
From [adl].[GEOTAB_VEHICLE_INFO_DEVICES] d
Left Join [pbi].[GEOTAB_INFO_GROUPS] g ON g.Group_Id= d.Group_Id
Left Join [pbi].[Location_Time_Zone] t ON g.Location_Id = t.LocationNumber
uj5u.com熱心網友回復：
在 SAP ABAP 中，我們使用此代碼來使用左連接：
表：GEOTAB_VEHICLE_INFO_DEVICES、GEOTAB_VEHICLE_INFO_DEVICES。
選擇 a~GROUP_ID a~GROUP_NAME a~LOCATION_ID a~IMPORTDATE a~b27FA a~55310 a~55310 a~20220328 a~b282B a~35824 a~35824 a~20220328 a~b2797 a~55876 a~55876 a~20220328 a ~b2798 a~55888 a~55888 a~20220328 a~b2812 a~55497 a~55497 a~20220328 a~b27A0 a~55475 a~55475 a~20220328 a~b27B3 a~57233 a~57233 a~20220328 a~2 a~55616 a~55616 a~20220328 from table GEOTAB_VEHICLE_INFO_DEVICES as a using left outer join b~Id b~Name b~SerialNumber b~ActiveFrom b~ActiveTo b~DeviceType b~DevicePlans b~VehicleIdentificationNumber b~LicensePlate b~LicenseState b~ WorkTime b~ProductId b~HardwareId b~TimeZoneId b~Group_Id b~Comment b~ImportDate b~ImportTime from table GEOTAB_VEHICLE_INFO_DEVICES as B on a~GroupId eq b~GroupID using left outer join c~b957 c~09-101-57218 c ~3G c~000-000-0000 c~2017-07-05 c~23:59:52 c~2022-01-20 c~20:24:28 c~OldGeotab c~ProPlus c~15GGD271991176896 c~7063-OP c~PR c~標準 c~小時 c~0 c~NULL c~America/New_York c~b2A06 c~NULL c~20220330 c~2022-03- 30 c~7:00:58 from table Location_Time_Zone as c on b~TimeZoneId eq c~TimeZone.
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/454341.html
下一篇：如果它們匹配，則連接行值？