帮忙写个Sql语句!!急
A表 id, adman
B表 id,Sn_id
C表 id,mem_id,title
关系是这样的:
a.adman=b.sn_id
b.id=c.mem_id
我想取出adman和title这两个字段,sql语句应该怎么写??
问题点数：20、回复次数：11Top
1 楼Haiwer（海阔天空）回复于 2006-06-02 13:59:26 得分 0
select b.sn_id as adman,c.title
from b,c
where b.id=c.mem_id
Top
2 楼itblog（Just for wife!）回复于 2006-06-02 14:05:21 得分 0
select a.adman,c.title from A,B,C where a.adman=b.sn_id and b.id=c.mem_idTop
3 楼woxiangfang（小黑黑脸）回复于 2006-06-02 14:06:50 得分 0
select a.adman adman,c.title title
from a,b,c
where a.adman=b.sn_id and b.id=c.mem_idTop
4 楼petercsdn（两袖清风）回复于 2006-06-02 14:12:29 得分 0
select * from A,B,C where a.adman=b.sn_id
b.id=c.mem_id
Top
5 楼godfather_wang（）回复于 2006-06-02 14:22:02 得分 0
select a.adman,c.title from a,b,c where a.adman=b.sn_id and b.id=c.mem_id
Top
6 楼Reeezak（坚持信念）回复于 2006-06-02 14:36:52 得分 0
SELECT B.SN_ID AS ADMAN, C.TITLE FROM
TABLE_B AS B
INNER JOIN
TABLE_C AS C
ON B.ID = C.MEM_IDTop
7 楼jueranliqv（MilanNello）回复于 2006-06-02 14:49:57 得分 0
都对，还写那么多干么Top
8 楼nann32258（大小迷糊,以前是我迷糊,现在我不想再迷糊了,但是别人也忑精明了点,他们怎么也不迷糊）回复于 2006-06-02 17:14:22 得分 0
看楼主能不能 给分喽.Top
9 楼zhxy_1208（）回复于 2006-06-03 10:51:56 得分 0
简单Top
10 楼zhxy_1208（）回复于 2006-06-03 10:53:47 得分 0
第一位同志答案是不是有点问题Top
11 楼wlinglong（灵龙）回复于 2006-06-03 11:02:16 得分 0
select b.sn_id as adman , title from b,c where b.id=c.mem_idTop
