简单SQL语句

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 


请大家帮我看看 哪里有问题啊？
执行有错误

---

你把表别名作为select的对象？！

应该是：

select u.column...,c.column...,u1.column...

---

and u.umc_Company_Id = c.id

---

列名有误。。。

---

列名怎么成表名了？

---

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

顶！

---

别名和列名不能混淆

---

引用

SQL code
--这样？
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

……

顶

---

新手学习来了

---

crazy boy

---

SQL code:
SELECT *
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

---

SQL code

---

Code highlighti