English
执行
Advancing each generation.
消费类电子产品
概览
应用 + 设计
产品 + 服务
新闻
电子期刊
消费类电子产品博客（仅限英语）
区域
联系我们
Select an Australian State
---------------------
SELECT DISTINCT cl.province FROM Locations l INNER JOIN cd_contacts_language cl ON cl.contact_id IN (SELECT TOP 1 contact_id FROM cd_relationships r WHERE r.location_id = l.code AND r.active_flag = 'y' ORDER BY sort_order) Where cl.Province IS NOT NULL AND (l.active <> '1' or l.active is null) AND Market_Code LIKE '%CEL%' AND UPPER(l.country) = 'AUSTRALIA' ORDER BY cl.province
Victoria
Or view a list of all Australia locations below
国家
城市
公司名称
Australia
Clayton, Victoria
Alcoa Fastening Systems -- Melbourne Operations
Or view a list of all Australia locations below 