Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select B.NameDastgahID, B.ZarfiateHamleBar, B.SherkateSazande, B.BisimHF, B.KanalBisimKhodroyi, B.ShomarePelak, B1.NameDastgahTitle, B2.NameKhodroTitle, B3.NoeKhodroTitle, B4.KarbarieKhodroTitle, B5.ShahreKhodroTitle, B6.cheraghgardanValue, B7.bisimHFTitle
- from dw.bohran_fct_etelaatenavegankhodroyi B
- INNER JOIN dw.excel_dim_namedastgah B1 using (NameDastgahID)
- INNER JOIN dw.excel_dim_namekhodro B2 using (NameKhodroID)
- INNER JOIN dw.excel_dim_noekhodro B3 using (NoeNavganID)
- INNER JOIN dw.excel_dim_karbariekhodro B4 using (KarbariID)
- INNER JOIN dw.excel_dim_shahrekhodro B5 using (ShahrID)
- INNER JOIN dw.excel_dim_cheraghgardan B6 using (CheraghGardan)
- INNER JOIN dw.excel_dim_bisimhf B7 using (bisimHF)
- where NameKhodroID = '630'
- select *
- from dw.bohran_fct_etelaatenavegankhodroyi
- bohran_fct_etelaatenavgankhodroyidetailsbohran_fct_etelaatenavegankhodroyi
- where NameKhodroID = '630'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement