Select distinct store
from store_Desc

select cmp_id,state,sde
from xyz
where store in (
select distinct store
from sql server table)