共有6个表
urlservice，cbe_subscriber_dyn，ts_productorder，cbe_subscriber，cbe_account_dyn，tc_account_balance
首先根据url条件查询第一个表（urlservice）需要subscriberkey 字段
select subscriberkey from urlservice where url='';
cbe_subscriber_dyn，ts_productorder，cbe_subscriber，cbe_account_dyn，tc_account_balan
上面五个表都有关联表（urlservice）的subscriberkey字段
cbe_subscriber_dyn 查询aaa字段
ts_productorder，查询bbb字段
cbe_subscriber，查询ccc字段
cbe_account_dyn，查询ddd字段
tc_account_balan，查询eee字段
这样的sql语句怎么写啊···因为数据量很多··性能要求好点的
请大家讨论一下写法···谢谢
看你是想得到什么结果了，如果是
cbe_subscriber_dyn，ts_productorder，cbe_subscriber，cbe_account_dyn，tc_account_balan 这几张表的
subscriberkey 在 urlservice 里都需要有对应subscriberkey的时候（即urlservice里有subscriberkey对应的值时，在其他5张表都必須有才显示出来），相应的SQL语句是：
[code="sql"]SELECT U.SUBSCRIBERKEY ,U.URL,A.AAA,B.BBB,C.CCC,D.DDD,E.EEE FROM
CBE_SUBSCRIBER_DYN A,TS_PRODUCTORDER B,
CBE_SUBSCRIBER C,CBE_ACCOUNT_DYN D,TC_ACCOUNT_BALAN E,
URLSERVICE U
WHERE A.SUBSCRIBERKEY = U.SUBSCRIBERKEY AND B.SUBSCRIBERKEY=U.SUBSCRIBERKEY
AND C.SUBSCRIBERKEY = U.SUBSCRIBERKEY AND D.SUBSCRIBERKEY=U.SUBSCRIBERKEY
AND E.SUBSCRIBERKEY = U.SUBSCRIBERKEY[/code]
如果是显示所有主表的值，子表如果存在值，就显示，不存在就当空字段的话，然后再跟据过滤条件过滤的，可以参考下面的SQL语句
[code="sql"]
SELECT U.SUBSCRIBERKEY, U.URL,A.AAA,B.BBB,C.CCC,D.DDD,E.EEE
FROM URLSERVICE U
LEFT JOIN CBE_SUBSCRIBER_DYN A ON A.SUBSCRIBERKEY = U.SUBSCRIBERKEY
LEFT JOIN TS_PRODUCTORDER B ON B.SUBSCRIBERKEY=U.SUBSCRIBERKEY
LEFT JOIN CBE_SUBSCRIBER C ON C.SUBSCRIBERKEY = U.SUBSCRIBERKEY
LEFT JOIN CBE_ACCOUNT_DYN D ON D.SUBSCRIBERKEY=U.SUBSCRIBERKEY
LEFT JOIN TC_ACCOUNT_BALAN E ON E.SUBSCRIBERKEY = U.SUBSCRIBERKEY
WHERE U.URL ＝？
[/code]
具体还得看你这几张几表跟主表这间的关系。。
select u.subscriberkey ,a.aaa,b.bbb,c.ccc,d.ddd,e.eee from
cbe_subscriber_dyn a，ts_productorder b，
cbe_subscriber c，cbe_account_dyn d，tc_account_balan e,
urlservice u
where a.subscriberkey = u.subscriberkey and b.subscriberkey=u.subscriberkey
and c.subscriberkey = u.subscriberkey and d.subscriberkey=u.subscriberkey
and e.subscriberkey = u.subscriberkey and u.url=?
分别在各表的subscriberkey建索引
采用union吧
[code="sql"]
select u.subscriberkey ,a.aaa from urlservice u,cbe_subscriber_dyn a
where a.subscriberkey = u.subscriberkey and u.url=?
union
select u.subscriberkey ,b.bbb from urlservice u, ts_productorder b
where b.subscriberkey = u.subscriberkey and u.url=?
union
select u.subscriberkey ,c.ccc from urlservice u, cbe_subscriber c
where c.subscriberkey = u.subscriberkey and u.url=?
union
select u.subscriberkey ,d.ddd from urlservice u, cbe_account_dyn d
where d.subscriberkey = u.subscriberkey and u.url=?
union
select u.subscriberkey ,e.eee from urlservice u, tc_account_balan e
where e.subscriberkey = u.subscriberkey and u.url=?
[/code]