SELECT NVL(kdanspre.timestamp,kunden.kkundnr) as index, kunden.kundnr as kundennr,NVL(alltrim(kdanspre.vorname)+IIF(!EMPTY(alltrim(kdanspre.vorname))," ","")+alltrim(kdanspre.name),kunden.kurzbez) as AName,NVL(kdanspre.name,'') as Nachname,NVL(kdanspre.vorname,'') as vorname,NVL(kdanspre.position,'') as position,kunden.kurzbez,kunden.strasse,kunden.plz,kunden.ort,kunden.land_lang,NVL(kdanspre.abteilung,'') as abteilung,NVL(kdanspre.telefon,'') as telefon1,kunden.telefon1 as telefon2,NVL(kdanspre.ptelefon,'') as telefonPriv,NVL(kdanspre.handy,'') as handy,NVL(kdanspre.phandy,'') as handyPriv,NVL(kdanspre.email,'') as email,NVL(kunden.inet1,'') as inet1 from mksdata!kunden LEFT JOIN mksdata!kdanspre ON kunden.kundnr=kdanspre.kundnr
|