新建的表，但是引用其中的列名时总是提示标示符无效，求大神帮忙，自己查了很多资料也没用搞定~~~~(>_<)~~~~

[geomarine]

这是我建的表结构
drop table PURSE_SEINE purge;
create table PURSE_SEINE
(
SHIPID NUMBER(10),
SHIPNAME VARCHAR2(32),
LENGTH NUMBER(3),
POWER NUMBER(5)，
WOrK_TYPE VARCHAR2(16),
WORK_METHOD VARCHAR2(16),
SHIP_MATE VARCHAR2(16)，
LICENCE VARCHAR2(64),
SPECIAL_LICENCE VARCHAR2(64),
WORK_PLACE VARCHAR2(64),
MAN_NUM NUMBER(5) ）
向里面插入数据可以，然后
select fisher.shipname,fisher.shipid from fisher where fisher.shipid = purse_seine.shipid;
提示
总是提示purse_seine.shipid标示符无效，这是为什么，大神们帮忙看看

[geomarine]

自己顶一下

[没什么是无所不能的]

select fisher.shipname,fisher.shipid from fisher,purse_seine where fisher.shipid = purse_seine.shipid;

[lyangsoft]

SELECT FISHER.SHIPNAME, FISHER.SHIPID
  FROM FISHER,PURSE_SEINE --你把PURSE_SEINE漏掉了
 WHERE FISHER.SHIPID = PURSE_SEINE.SHIPID;

[c_sdn_shang_bu_qi]

select fisher.shipname,fisher.shipid from fisher where fisher.shipid = purse_seine.shipid; 改为 select A.shipname,A.shipid from fisher A,purse_seine B where A.shipid = B.shipid; 一般给个别名，不然写敲那么多字符还容易错

[xiu973402]

因为你后面 where 是两个表的内容，可是前面 from 只有一个表信息，这当然会提示你报错了。

[geomarine]

引用 2 楼 wenyzh 的回复:

select fisher.shipname,fisher.shipid from fisher,purse_seine where fisher.shipid = purse_seine.shipid;

新手，(*^__^*) 嘻嘻…… O(∩_∩)O谢谢

[geomarine]

引用 3 楼 u012355452 的回复:

SELECT FISHER.SHIPNAME, FISHER.SHIPID
  FROM FISHER,PURSE_SEINE --你把PURSE_SEINE漏掉了
 WHERE FISHER.SHIPID = PURSE_SEINE.SHIPID;

是的呢，后来老师帮我指出来了，新手哈，O(∩_∩)O谢谢帮助，(*^__^*) 嘻嘻……

[geomarine]

引用 4 楼 c_sdn_shang_bu_qi 的回复:

select fisher.shipname,fisher.shipid from fisher where fisher.shipid = purse_seine.shipid; 改为 select A.shipname,A.shipid from fisher A,purse_seine B where A.shipid = B.shipid; 一般给个别名，不然写敲那么多字符还容易错

新手，还没有掌握要领，O(∩_∩)O谢谢大神，我会好好领悟的，么么哒