查询客户表关系

1.查询客户

p_Customer 客户表

SELECT * from p_Customer where MobileTel = '13710019001'

2.查询机会oppguid

s_opp2Cst   机会客户关系表

SELECT * from [s_Opp2Cst ] where CstGUID in 
(SELECT CstGUID from p_Customer where MobileTel = '13710019001')

3.查询机会

根据关系表查到机会guid 

SELECT
    *
FROM
    s_Opportunity
WHERE
    OppGUID IN (
        SELECT
            OppGUID
        FROM
            [s_Opp2Cst ]
        WHERE
            CstGUID IN (
                SELECT
                    CstGUID
                FROM
                    p_Customer
                WHERE
                    MobileTel = '13710019001'
            )
    )

4.跟进查询