SELECT * FROM TL.V_SEARCH_LOCATION_LIST WHERE ENTID=‘01‘;


SELECT * FROM TL.V_SEARCH_LOCATION_DETAIL WHERE LOCATION_ID=‘38‘;


SELECT * FROM TL.V_SEARCH_PROJECT_LIST WHERE LAND_ID=‘L01202104210004‘;


SELECT * FROM TL.V_SEARCH_BUILDER WHERE ID=‘SGF100001‘;



SELECT
    TT.*, T4.BUILDER,
    T4.LEGAL_PERSON,
    T4.LEGAL_PERSON_PHONE,
    T4.STATE
FROM
    (
        WITH T AS (
            SELECT DISTINCT
                T1.FILENO,
                T2.LANDID
            FROM
                TL.V_SEARCH_LOCATION_LIST T1,
                TL.V_SEARCH_LOCATION_DETAIL T2
            WHERE
                T1.ENTID = ‘01‘
            AND T1."LOCATION" = T2.LOCATION_ID
            AND T2.LANDID IS NOT NULL
        ) SELECT
            T.LANDID, 
            T.FILENO,
            T3.PROJECT_NAME,
            T3.PLAN_START_DATE,
            T3.PLAN_END_DATE,
            T3.BUILDER,
            T3.STATE STATE1
        FROM
            T,
            TL.V_SEARCH_PROJECT_LIST T3
        WHERE
            T3.LAND_ID = T .LANDID
    ) TT,
    TL.V_SEARCH_BUILDER T4
WHERE
    T4. ID = TT.BUILDER;