35 lines
971 B
SQL
35 lines
971 B
SQL
SELECT TOP 100
|
|
dm1.Address_ID
|
|
,dm1.AD_first_name
|
|
,dm1.AD_last_name
|
|
,dm1.AD_middle_name
|
|
,dm1.AD_name
|
|
--,LEFT(SUBSTRING(ad_name, 0, CHARINDEX(' ', AD_name, 0)), 30) AS first
|
|
--,UPPER(LEFT(SUBSTRING(ad_name, CHARINDEX(' ', AD_name, 0), 99), 30)) AS last
|
|
,dm1.AD_address_1
|
|
,dm1.AD_address_2
|
|
,dm1.AD_address_3
|
|
,dm1.AD_zip_code
|
|
,dm1.AD_city
|
|
|
|
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
|
|
)
|
|
AND dm1.AD_sex <> 4
|
|
|
|
|
|
SELECT *
|
|
FROM ArizonaREP.dbo.Address a
|
|
WHERE a. |