求sql语句，答案正确立即给分

[cxiaobao]

有三个表，结构如下：
表1： customize_info:
(
id number(10) not null,

//这个publish_id与publish_info中的id对应
publish_id number(10) not null,

//这个user_id 与 user中的id对应
user_id number(10) not null,

status varchar2(1)
)

表2： publish_info:
(
id number(10) not null,

//这个user_id 与 user中的id对应
user_id number(10) not null,

msg varchar2(1024) not null
)

表3： user
(
id number(10) not null,
phone varchar2(20) not null
)


我现在想做的操作是这样的。
1：从表customize_info中取出status是null的记录
select id, publish_id, user_id userid1 from customzie_info where status is null

2:遍历上面的结果，对每一条记录做如下操作：
select phone from user where id = (value of userid1)

select user_id userid2,msg from publish_info where id = publish_id

select phone from user where id = (value of userid2)

我的问题是能不能查询一次数据库就把我所要的东西查出来呢？
我使用下面的语句：
select a.msg content ,b.phone fromphone, c.id infoid, d.phone tophone
from publish_info a ,user b ,customize_info c ,user d
where a.user_id = b.id
and a.id =c.publish_id
and d.id = c.user_id
and c.status is null

但结果是错的。（好象叉乘了）

正确的sql语句该怎么写？（或者不可能？）

[athere_08]

这样：select phone
from customzie_info ,user
where status is null
UNION
select phone
from customzie_info , publish_info,user
where customzie_info.status is null
and publish_info.publish_id=customzie_info.publish_id
and publish_info.user_id=user.id
没这样用过，不知可不可以。

[hydnoahark]

select A.id, A.publish_id, A.user_id as userid1
,B.phone
,C.user_id as userid2,C.msg
,D.phone
from customzie_info as A
inner join user as B
on A.user_id=B.id
inner join publish_info as C
on A.publish_id=C.id
inner join user as D
on C.user_id=D.id
where A.status is null

[qybao]

试试
select ta.fromphone,tb.msg,tb.tophone
from (select A.phone as fromphone,B.publish_id as pid from [user] A,customzie_info B where B.status is not null and A.id=B.user_id) as ta,
(select C.msg as msg,C.publish_id as pid,D.phone as tophone from publish_info C,[user] D where C.user_id=D.id) as tb
where ta.pid=tb.pid

[huxiaobo]

试一下：SELECT a.id, a.publish_id, a.user_id a.userid1 b.phone c.user_id c.userid2,c.msg
from customzie_info a ,user b ,publish_info c,
where (status is null)
AND a.id in (select userid1 from user)
AND a.publish_id in (select publish_id from publish_info)
AND a.id in (select userid2 from user)

[cxiaobao]

非常感谢谢各位老大的热心帮助，问题解决了！这个帖子在数据库版还有一份：请各位去拿分。
http://www.csdn.net/expert/topic/1095/1095721.xml?temp=.3346979