In SQL Server, you'd need brackets around the name "Add":
Select l.[add], l.phne
from e_lkup l
where mins is null
GROUP BY phne, [add]
HAVING count(*) >1
EXCEPT
select l.[add], l.phne
from s_status ss
left outer join e_lkup l
on l.mcs = ss.mcs
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.