Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT rest.Id, rest.Code, filial.Name filial, reg.Name Region, rest.PriceCode, codeT.Name
- , rest.IsActive, rest.BegDate, rest.EndDate, codeT.Priority*geo.Priority Priority
- FROM MARKET.dbo.[restrict] rest
- INNER JOIN restrictGeoLevel geo ON rest.GeoLevelId = geo.Id
- INNER JOIN codeType codeT ON codeT.Id = rest.CodeTypeId
- LEFT JOIN cnFilial filial ON filial.Id = rest.FilialId
- LEFT JOIN region reg ON reg.Id = rest.RegionId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement