Skip to content
Advertisement

How to use get value from multiple tables using left join?

I have these 3 Tables. Now I need to show the timezone name from the timezone table in the Devices Table by using left join. How can i do that? Please Help

Table Name : [pbi].[GEOTAB_INFO_GROUPS]

Table Name : [adl].[GEOTAB_VEHICLE_INFO_DEVICES]

Table Name : [pbi].[Location_Time_Zone]

I Am trying like this but not getting the correct result

Advertisement

Answer

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement