Untitled

/* AND / OR für News-versand */
SELECT liefnr AS Lieferantennummer, CONCAT(firma1, ' ' , firma2) AS Firma, email1 as Mail
FROM dbo.lieferanten
WHERE email1 IS NOT NULL AND land = 'D'

/* AND / OR random stuff */
SELECT persnr AS Personalnummer, abteilung as Abteilung, akadgrad as Akademischer_Grad, nachname as Nachname, vorname as Vorname, land as Land
FROM dbo.personal
WHERE eintritt <= '2005-01-02' AND geschlecht = 2
OR abteilung = 'VK' AND land = 'D' AND akadgrad IS NOT NULL AND geschlecht = 2


/* Random <= / >= Stuff */
SELECT persnr AS Personalnummer, abteilung as Abteilung, nachname as Nachname, vorname as Vorname, s.bezeichnung as Status_Arbeit
FROM dbo.personal p
JOIN dbo.wareneingang w on w.bearbeiter = p.persnr
JOIN dbo.status s on w.status = s.stid
WHERE w.bearbeiter >= '900' AND w.status <= 2