select a.pub_name from publishers a, pub_id b where a.pub_id=b.pub_id and b.type='business'
ct a.pub_name from publishers a, titles b where a.pub_id=b.pub_id and b.type='business'
在 pubs 库 ,试一下 你们方法, 有3 行重复 ,而 SELECT pub_name FROM publishers WHERE pub_id IN (SELECT pub_id FROM titles WHERE type = 'business') 没有
select distinct pub_name from publishers ,titles where type='business' and publishers.pub_id=titles.pub_id
SELECT distinct pub_name FROM publishers WHERE pub_id IN (SELECT pub_id FROM titles WHERE type = 'business') or SELECT distinct pub_name FROM publishers a join titles b on a.pub_id=b.pub_id where b.type = 'business'or SELECT distinct pub_name FROM publishers a,titles b where a.pub_id=b.pub_id and b.type = 'business'
where a.pub_id=b.pub_id and b.type='business'
where a.pub_id=b.pub_id and b.type='business'
pub_id FROM titles WHERE type = 'business') 没有
where type='business' and publishers.pub_id=titles.pub_id
pub_id FROM titles WHERE type = 'business') or SELECT distinct pub_name FROM publishers a join titles b on a.pub_id=b.pub_id
where b.type = 'business'or SELECT distinct pub_name FROM publishers a,titles b where a.pub_id=b.pub_id
and b.type = 'business'
这里有老龟奴zyq_123雍亲正当大版主,还有人称辣花摧魔前青楼名妓smoke当镇小版主,肯定能满足您的需要!!!快来吧~~~~~~