aTypeID aID aName peopleID pID type1 A 1AAA 1111 A type1 B 1BBB 1111 B type1 C 1CCCtype1 D 1CCC --2CCC ??select a.aTypeID,a.aID,a.aName,b.peopleID,b.pID from table1 a,table2 b where b.pID(+)=a.aID不知道是不是这个意思
select a.aTypeID,a.aID,a.aName,b.peopleID,b.pID from table1 a,table2 b where a.aID=b.pID(+) and substr(a.aTypeID,5,1)=substr(b.peopleID,4,1);
to hevin: a.aTypeID和b.peopleID是没有关系的to dinya2003(OK): aTypeID就是表1中的
type1 A 1AAA 1111 A
type1 B 1BBB 1111 B
type1 C 1CCCtype1 D 1CCC --2CCC ??select a.aTypeID,a.aID,a.aName,b.peopleID,b.pID
from
table1 a,table2 b
where b.pID(+)=a.aID不知道是不是这个意思
from
table1 a,table2 b
where a.aID=b.pID(+) and substr(a.aTypeID,5,1)=substr(b.peopleID,4,1);
a.aTypeID和b.peopleID是没有关系的to dinya2003(OK):
aTypeID就是表1中的