SELECT chln_prefix,chln_no FROM PC except SELECT prefix,doc_no FROM PB
SELECT chln_prefix,chln_no,chln_name FROM PC except SELECT prefix,doc_no FROM PB
SELECT chln_prefix,chln_no,chln_name FROM PC EXCEPT SELECT prefix,doc_no, 0 AS DummyValue FROM PB
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)