====== SQL-Abfragen Conpower ======

==== Kunden eines ADM (Schleising)====
<code sql>

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')
</code>

==== Kunden von Rüger ====
<code sql>
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')</code>