More Than Two Matching Company Records Not In OrgChart
Type: MSSQL
Description: More Than Two Matching Company Records Not In OrgChart - We use GoldBox to add contact records automatically to company name based orgcharts. If users enter a record with no value in contact it doesn’t add the record. We use this to find any records where there are two matching company names but they have not been put together into an OrgChart based on company name.
- SELECT
- c1.company
- ,c1.contact
- ,c1.accountno
- FROM
- contact1 c1
- WHERE
- c1.company > ''
- AND c1.company IN
- (SELECT
- company
- FROM
- contact1
- WHERE
- company > ''
- GROUP BY
- company
- HAVING
- COUNT(company) > 1)
- AND c1.accountno NOT IN
- (SELECT
- accountno
- FROM
- contsupp
- WHERE
- rectype = 'O')
[link]
Leave a Reply
You must be logged in to post a comment.
