works:
select cdr.src from cdr where cdr.src not in
(select callerid.cid_number from callerid)
order by cdr.src;
works:
select cdr.dst from cdr where cdr.dst not in
(select callerid.cid_number from callerid)
order by cdr.dst;
syntactically correct, but doesn't seem to be returning correct results:
select concat(cdr.src, "/", cdr.dst) as callrec from cdr
where cdr.src not in (select callerid.cid_number from callerid)
and cdr.dst not in (select callerid.cid_number from callerid)
order by callrec;