select count(*) as badlinks from tbl_doc_documents a, tbl_fsc_content b where a.contentid = b.contentid and mainfolder <> fsl_tablecode + convert(varchar(10), ownerid) and mainfolder = 'mfr957' Found #qcf_badlinks.badlinks# bad content links, caused by foodhandler packaging system.