MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.
Alter View ATLAS_Segment (Atlas_Level) SELECT dbo.Segment.ROADJUR, dbo.Segment.Street_Full_Name, dbo.Segment.L_F_ADD, dbo.Segment.L_T_ADD, dbo.Segment.R_F_ADD, dbo.Segment.R_T_ADD, (SELECT Ward_Name FROM dbo.Ward AS W WHERE (Ward_ID = dbo.Segment.Left_Mun_ID)) AS L_MUNAME, (SELECT Ward_Name FROM dbo.Ward AS W WHERE (Ward_ID = dbo.Segment.Right_Mun_ID)) AS R_MUNAME FROM dbo.Segment INNER JOIN dbo.Ward ON dbo.Segment.Left_Mun_ID = dbo.Ward.Ward_ID AND dbo.Segment.Right_Mun_ID = dbo.Ward.Ward_ID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.