Table of Contents

SQL-Abfragen Conpower

Kunden eines ADM (Schleising)

SELECT strTypeShortName AS STATUS, kd_Name, kd_name2, kd_adresse, kd_land, kd_ort, kd_tel, kd_email, kd_fax
FROM tbl_Kunde k INNER JOIN tblAdressType s ON s.ID = kd_lieferant 
WHERE kd_ma_id = (SELECT ma_id FROM tbl_mitarbeiter WHERE ma_nachname = 'Schleising')

Kunden von Rüger

SELECT KD_ID AS ID, kd_Name, kd_name2, kd_adresse, kd_land, kd_ort,kd_plz, kd_tel,
MZust.Ma_NachNAME AS Zuständiger,
VK.strVertriebskanalText AS Vertriebskanal,
strCustomerPriorityShort AS Prioritaet,
strTypeShortName AS STATUS,
AktivVon
FROM tbl_Kunde k INNER JOIN tblAdressType s ON s.ID = kd_lieferant
LEFT OUTER JOIN tblVertriebskanal VK ON VK.IDCPVertriebskanal = K.IDCPVertriebskanal
LEFT OUTER JOIN tblCustomerPriority CP ON CP.intCustomerPriorityID = K.intCustomerPriority
LEFT OUTER JOIN tbl_mitarbeiter MZust ON MZust.MA_ID = KD_MA_ID
WHERE
 
(kd_plz LIKE '6%' OR kd_plz LIKE '7%' OR kd_plz LIKE '8%')
AND strTypeShortName IN ('A', 'KiV', 'K', 'I')