SELECT a.aname, b.bname FROM c, a, b WHERE c.aid = a.aid AND c.bid = b.bid AND a.aname IS NOT NULL AND b.bname IS NOT NULL;
select a.aname,b.bname from a,b,c where a.aid=c.aid and c.bid=b.bid and a.aname is not null and b.bname is not null
--不就是这样吗? SELECT a.aname, b.bname FROM c, a, b WHERE c.aid = a.aid AND c.bid = b.bid AND a.aname IS NOT NULL AND b.bname IS NOT NULL;--或者是这样? SELECT a.aname, b.bname FROM c, a, b WHERE c.aid(+) = a.aid AND c.bid(+) = b.bid AND a.aname IS NOT NULL AND b.bname IS NOT NULL;
应该是以C表数据为准,关联A,B表查询出A.aname和B.bname select a.aname,b.bname from a ,b , c where a.aId = c.aId and b.bId = c.bId and a.aname is not NULL and b.bname is not NULL
SELECT a.aname, b.bname FROM c, a, b WHERE c.aid = a.aid AND c.bid = b.bid AND a.aname IS NOT NULL AND b.bname IS NOT NULL; right
FROM c, a, b
WHERE c.aid = a.aid AND
c.bid = b.bid AND
a.aname IS NOT NULL AND
b.bname IS NOT NULL;
from a,b,c
where a.aid=c.aid and c.bid=b.bid and a.aname is not null and b.bname is not null
SELECT a.aname, b.bname
FROM c, a, b
WHERE c.aid = a.aid AND c.bid = b.bid AND
a.aname IS NOT NULL AND b.bname IS NOT NULL;--或者是这样?
SELECT a.aname, b.bname
FROM c, a, b
WHERE c.aid(+) = a.aid AND c.bid(+) = b.bid AND
a.aname IS NOT NULL AND b.bname IS NOT NULL;
select a.aname,b.bname
from a ,b , c
where a.aId = c.aId
and b.bId = c.bId
and a.aname is not NULL
and b.bname is not NULL
SELECT a.aname, b.bname
FROM c, a, b
WHERE c.aid = a.aid
AND
c.bid = b.bid
AND
a.aname IS NOT NULL
AND
b.bname IS NOT NULL;
right