ABCDDB.sql

SELECT
  --ZABCDRECORD.Z_PK AS 'ID',
  ZABCDRECORD.ZFIRSTNAME AS 'First Name',
  ZABCDRECORD.ZLASTNAME AS 'Last Name',
  ZABCDPOSTALADDRESS.ZSTREET AS 'Street',
  ZABCDPOSTALADDRESS.ZZIPCODE AS 'Postal code',
  ZABCDPOSTALADDRESS.ZCITY AS 'City',
  ZABCDPHONENUMBER.ZFULLNUMBER AS 'Phone',
  ZABCDEMAILADDRESS.ZADDRESS AS 'Email'
FROM
  ZABCDRECORD
LEFT OUTER JOIN
  ZABCDPOSTALADDRESS ON ZABCDRECORD.Z_PK=ZABCDPOSTALADDRESS.ZOWNER
LEFT OUTER JOIN
  ZABCDEMAILADDRESS ON ZABCDRECORD.Z_PK=ZABCDEMAILADDRESS.ZOWNER
LEFT OUTER JOIN
  ZABCDPHONENUMBER ON ZABCDRECORD.Z_PK=ZABCDPHONENUMBER.ZOWNER
WHERE
  NOT (ZABCDRECORD.Z_PK=1 OR ZABCDRECORD.Z_PK=2 OR ZABCDRECORD.Z_PK=4);