34 lines
864 B
SQL
34 lines
864 B
SQL
USE Arizona
|
|
|
|
SELECT
|
|
dm1.AD_first_name
|
|
,dm1.AD_last_name
|
|
,dm1.AD_middle_name
|
|
,dm1.AD_name
|
|
,dm1.AD_address_1
|
|
,dm1.AD_address_2
|
|
,dm1.AD_address_3
|
|
FROM dbo.Address dm1
|
|
--JOIN dbo.Customer c ON c.CUST_add_turnover_to = dm1.address_id
|
|
--or c.cust_address = dm1.address_id
|
|
--or c.cust_bill_to = dm1.address_id
|
|
--or c.cust_send_bill_to = dm1.address_id
|
|
--or c.cust_ship_to = dm1.address_id
|
|
where exists(
|
|
select 1
|
|
from dbo.customer c
|
|
where c.CUST_add_turnover_to = dm1.address_id
|
|
or c.cust_address = dm1.address_id
|
|
or c.cust_bill_to = dm1.address_id
|
|
or c.cust_send_bill_to = dm1.address_id
|
|
or c.cust_ship_to = dm1.address_id
|
|
)
|
|
|
|
RETURN
|
|
|
|
|
|
SELECT *
|
|
FROM dbo.Address_category ac
|
|
JOIN dbo.Address_category_text act ON act.ADCT_address_category = ac.Address_category_ID
|
|
WHERE act.ADCT_language = 1 --fr
|