select
a.*,b.*
from expert_info a
inner join receive_user b
on b.order_title like '%'||a.order_title||'%' and a.area_id=b.area_id这样写SQL语句为什么不对,怎么改?
a.*,b.*
from expert_info a
inner join receive_user b
on b.order_title like '%'||a.order_title||'%' and a.area_id=b.area_id这样写SQL语句为什么不对,怎么改?
a.*,b.*
from expert_info a
inner join receive_user b
on a.area_id=b.area_id
where b.order_title like '%'||a.order_title||'%';
------------try
select
a.*,b.*
from expert_info a , receive_user b
where b.order_title like '%'||a.order_title||'%' and a.area_id=b.area_id
-------------------- ---------- --------------------
中国科学技术大学 1 科学
SQL> select * from b;NAME ID
-------------------- ----------
中国科学技术大学 1SQL> SELECT
2 a.*,b.*
3 FROM a
4 INNER JOIN b
5 ON b.NAME LIKE '%'||a.order_title||'%' AND a.ID=b.ID ;NAME ID ORDER_TITLE NAME
-------------------- ---------- -------------------- --------------------
ID
----------
中国科学技术大学 1 科学 中国科学技术大学
1
SQL>
还是一样的错误,语法错误 :
ORA-00904 "A"."order_title" 标识符无效
create table receive_user(area_id int,order_title varchar2(20));insert into receive_user values(1,'Happy 2009 new year');
insert into expert_info values(1,'new');SQL> run
1 select
2 a.*,b.*
3 from expert_info a
4 inner join receive_user b
5* on b.order_title like '%'||a.order_title||'%' and a.area_id=b.area_id AREA_ID ORDER_TITLE AREA_ID ORDER_TITLE
---------- -------------------- ---------- --------------------
1 new 1 Happy 2009 new year
select
a.*,b.*
from expert_info a , receive_user b
where b.order_title like '%'||a.order_title||'%' and a.area_id=b.area_id
能解释下 WHERE 后面语句的意思吗?