¼òµ¥SQLÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí

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 


Çë´ó¼Ò°ïÎÒ¿´¿´ ÄÄÀïÓÐÎÊÌâ°¡£¿
Ö´ÐÐÓдíÎó

---

²»µÈÓÚ·ûºÅ´íÎó »»³É<>

---

ÒýÓÃ

²»µÈÓÚ·ûºÅ´íÎó »»³É<>

sorry

select *  
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; 
ÕâÑùÊÔÊÔ

---

select u,c,u1  
from umc_user_base u,umc_company_base c

ÕâÀïʶ±ð²»ÁË u,c,u1 £¬·Ö²»Çå³þÊÇÄĸö±íµÄ×ֵ䣬

---

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 
--------------------
ÎÊÌâ´óÁË£¬±íÃ÷²»ÄÜ×÷Ϊ×ֶεģ¬Äã¼ÈȻΪumc_user_baseÆðÁ˸öuµÄ±ðÃû£¬¾ÍÒª±£Ö¤Õâ¸ö±íÀïûÓÐuÕâ¸ö×ֶΣ¬·ñÔòÄãÖ»ÄÜÓÃ
select u."u"
from umc_user_base u
ÕâÑùµÄ²éѯÐÎʽ

---

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