select tuser.uid,tuser.name,tuser.uid
,(select ttype.type from ttype where ttype.id=tuser.Homepage_type_id)as homepage_type
,tuser.Homepage_Title ,tuser.homepage_logo ,tuser.Join_Time ,tuser.email ,tuser.oicq ,tuser.txt, i.*
from tuser
join (select tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T
,tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tinfo_n) i on i.uid=tuser.uid试试 !!!
,(select ttype.type from ttype where ttype.id=tuser.Homepage_type_id)as homepage_type
,tuser.Homepage_Title ,tuser.homepage_logo ,tuser.Join_Time ,tuser.email ,tuser.oicq ,tuser.txt, i.*
from tuser
join (select tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T
,tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tinfo_n) i on i.uid=tuser.uid试试 !!!
, ttype.type as homepage_type
,tuser.Homepage_Title ,tuser.homepage_logo ,tuser.Join_Time ,tuser.email ,tuser.oicq ,tuser.txt
, tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T
,tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tuser inner join tinfo_n on tinfo_n.uid=tuser.uid
inner jion ttype on ttype.id=tuser.Homepage_type_id
tuser.name,
tuser.uid,
ttype.type as homepage_type,
tuser.Homepage_Title ,
tuser.homepage_logo ,
tuser.Join_Time ,
tuser.email ,
tuser.oicq ,
tuser.txt,
tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T,
tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tuser, ttype, tinfo_n
where ttype.id=tuser.Homepage_type_id
and tinfo_n.uid=tuser.uid
, ttype.type as homepage_type
,tuser.Homepage_Title ,tuser.homepage_logo ,tuser.Join_Time ,tuser.email ,tuser.oicq ,tuser.txt
, tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T
,tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tuser left outer join tinfo_n on tinfo_n.uid=tuser.uid
left outer join ttype on ttype.id=tuser.Homepage_type_id
,tuser.Homepage_Title ,tuser.homepage_logo ,tuser.Join_Time ,tuser.email ,tuser.oicq ,tuser.txt, i.*
from tuser
join (select tinfo_n.All_N as All_N,
tinfo_n.All_T as All_T
,tinfo_n.Today_N as Today_N,
tinfo_n.Today_T as Today_N
from tinfo_n) i on i.uid=tuser.uid