看你是想得到什么结果了,如果是
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]
具体还得看你这几张几表跟主表这间的关系。。