>SELECT individual_ref from attribute where attribute.attribute_code = 'NOMAIL' > AND individual_ref IS NOT NULL >>
>>select s.* >>from sat_labellist s >>join all_inner_london_postcodes a >>on Replace(s.postcode, ' ', '')= a.postcode >>join member >>on s.[membership no] = member.membership_no >>where a.area = 'Lambeth' >>and s.type = 'Group' >>and LEN(s.[private email]) = 0 >>and member.individual_ref NOT IN (SELECT individual_ref from attribute where attribute.attribute_code = 'NOMAIL') >>>>