select F.[name],(select name from fubiao where id =Z.fuid),Z.bifen,Z.date from zhubiao as Z inner join fubiao as F on Z.zhuid = F.id where date > '2009-06-01'
select F.[name],(select name from fubiao where id =Z.fuid),Z.bifen,Z.date from zhubiao as Z inner join fubiao as F on Z.zhuid = F.id where date > '2009-06-01'