Need help with a query to extract data for supplier

Summary

Need help with a query to extract data for supplier, though query is generating output but few rows has missing data for sites and few sites are duplicating

Content

Need help with a query to extract data for supplier, though query is generating output but few rows has missing data for sites and few sites are duplicating.Can you please suggest what I am doing incorrect.

Select SV.VENDOR_NAME

,SV.VENDOR_ID

,SV.SEGMENT1

,SV.VENDOR_NAME_ALT

,SV.BUSINESS_RELATIONSHIP

,SV.ORGANIZATION_TYPE_LOOKUP_CODE

,SV.CREATION_DATE

,SV.LAST_UPDATE_DATE

,SV.LAST_UPDATED_BY

,SV.VENDOR_TYPE_LOOKUP_CODE