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
请大家帮我看看 哪里有问题啊?
执行有错误
from umc_company_base c,umc_user_base u,
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这里识别不了 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
--------------------
问题大了,表明不能作为字段的,你既然为umc_user_base起了个u的别名,就要保证这个表里没有u这个字段,否则你只能用
select u."u"
from umc_user_base u
这样的查询形式
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 这样试试看!