select 'Factuur Adres is niet volledig 'as A 
   from account a join debtor  d on a.WAccountid = D.WAccountid
  left join contacts on d.WContactID = Contacts.RECORDID
  left join countries c on c.countries_id = d.WPOSTCOUNTRIES_ID
 where a.WAccountid = <@WACCOUNTID@>
and ((d.SPOSTAL1 = '' or d.SPOSTAL2 = '' or d.SPOSTALCODE = '' or
c.COUNTRIES_NAME = '' )
or (d.SPOSTAL1 is null or d.SPOSTAL2 is null or d.SPOSTALCODE is null or
c.COUNTRIES_NAME is null )
)
@@GO@@
select 'Aflever Adres is niet volledig 'as A 
   from account a join debtor  d on a.WAccountid = D.WAccountid
  left join contacts on d.WContactID = Contacts.RECORDID
  left join countries c on c.countries_id = d.WDELCOUNTRIES_ID
 where a.WAccountid = <@WACCOUNTID@>
and ((d.SDELIVERY1 = '' or d.SDELIVERY2 = '' or d.SDELIVERYCODE = '' or
c.COUNTRIES_NAME = '' )
or
(d.SDELIVERY1 is null or d.SDELIVERY2 is null or d.SDELIVERYCODE is null or
c.COUNTRIES_NAME is null )
)
@@GO@@