什么意思啊?如下么?select * from person_basic_circs
where id not in
(
SELECT PERSON_BASIC_CIRCS.ID
FROM PERSON_BASIC_CIRCS INNER JOIN
PERSON_MATE ON
PERSON_BASIC_CIRCS.ID = PERSON_MATE.RELATION_ID
WHERE EXISTS
(SELECT *
FROM PERSON_MATE
WHERE PERSON_MATE.ID = PERSON_BASIC_CIRCS.ID)
) tmp
where id not in
(
SELECT PERSON_BASIC_CIRCS.ID
FROM PERSON_BASIC_CIRCS INNER JOIN
PERSON_MATE ON
PERSON_BASIC_CIRCS.ID = PERSON_MATE.RELATION_ID
WHERE EXISTS
(SELECT *
FROM PERSON_MATE
WHERE PERSON_MATE.ID = PERSON_BASIC_CIRCS.ID)
) tmp
SELECT *
FROM PERSON_BASIC_CIRCS INNER JOIN
PERSON_MATE ON
PERSON_BASIC_CIRCS.ID = PERSON_MATE.RELATION_ID
WHERE not EXISTS
(SELECT *
FROM PERSON_MATE
WHERE PERSON_MATE.ID = PERSON_BASIC_CIRCS.ID)
FROM a INNER JOIN
b ON
a.ID = b.ID
WHERE EXISTS
(SELECT *
FROM b
(这里重复了啊,没意义啊)WHERE b.ID = a.ID)
是矛盾的啊
该不会要如下效果吧
select * from a left outer join b on a.id=b.id
select * from a right outer join b on a.id=b.id
select * from a all outer join b on a.id=b.id
solidpanther(我爱机器猫) ( ) 信誉:100 2003-12-20 """""15:45:00 """""
怎么排到我前面去了啊,程序有毛病吧