select emp_id,emp_name,ot1_id,t1_name,t2_name,t3_name
from emp,t1,t2,t3,otl
where emp.t1_id=t1.t1_id(+)
and emp.t2_id=t2.t2_id(+)
and emp.t3_id=t3.t3_id(+)
and emp.emp_id=otl.emp_id(+)
and emp.emp_id like '%emp_id%'
and emp.emp_name like '%emp_name%'
and t1.t1_name(+) like '%t1_name%'
and t2.t2_name(+) like '%t2_name%'
from emp,t1,t2,t3,otl
where emp.t1_id=t1.t1_id(+)
and emp.t2_id=t2.t2_id(+)
and emp.t3_id=t3.t3_id(+)
and emp.emp_id=otl.emp_id(+)
and emp.emp_id like '%emp_id%'
and emp.emp_name like '%emp_name%'
and t1.t1_name(+) like '%t1_name%'
and t2.t2_name(+) like '%t2_name%'
如果在SQLSERVER中应该怎么写呢?
当t1.t1_name(+) like '%t1_name%' and t2.t2_name(+) like '%t2_name%'里的like里放进东西就不对。