select u,c,u1
from umc_user_base u,umc_company_base c
left join umc_user_base u1
on u1.CREATE_USER_ID = u.id
where 1=1
and u.umc_Company_Id = c.id
and nvl(c.is_Deleted, 0) != 1
请大家帮我看看 哪里有问题啊?
执行有错误
from umc_user_base u,umc_company_base c
left join umc_user_base u1
on u1.CREATE_USER_ID = u.id
where 1=1
and u.umc_Company_Id = c.id
and nvl(c.is_Deleted, 0) != 1
请大家帮我看看 哪里有问题啊?
执行有错误
SELECT u.*, c.*, u1.*
FROM umc_user_base u, umc_user_base u1, umc_company_base c
WHERE u1.CREATE_USER_ID(+) = u.id
AND u.umc_Company_Id = c.id
AND nvl(c.is_Deleted, 0) != 1
FROM umc_user_base u, umc_user_base u1, umc_company_base c
WHERE u1.CREATE_USER_ID(+) = u.id
AND u.umc_Company_Id = c.id
AND nvl(c.is_Deleted, 0) != 1顶!
FROM umc_user_base u, umc_user_base u1, umc_company_base c
WHERE u1.CREATE_USER_ID(+) = u.id
AND u.umc_Company_Id = c.id
AND nvl(c.is_Deleted, 0) != 1
select umc_user_base.*,umc_company_base.*,umc_user_base.*
from umc_user_base u,umc_company_base c
left join umc_user_base u1
on u1.CREATE_USER_ID = u.id
where 1=1
and u.umc_Company_Id = c.id
and nvl(c.is_Deleted, 0) != 1