再求sql写法，简单3库查询（特别是CoolSlob）

[deadhorse]

三个库：
g:
ID
Name

u:
ID
Name

o:
ID_g
ID_u1
ID_u2
...

在o库中选择ID_u=3的所有列，同时，ID_g对应g库的ID，显示成g.Name，ID_u1,ID_u2分别都对应u库的ID，显示成u.Name

[foolishchao]

select g.name,u1.name,u2.name
from o join g on o.id_g=g.id
join u u1 on o.id_u1=u1.id
join u u2 on o.id_u2=u2.id
where o.id_u=3

[foolishchao]

select g.name,u1.name,u2.name
from o join g on o.id_g=g.id
join u u1 on o.id_u1=u1.id
join u u2 on o.id_u2=u2.id
where o.id_u=3

[foolishchao]

select g.name gname,u1.name u1name,u2.name u2name
from o join g on o.id_g=g.id
join u u1 on o.id_u1=u1.id
join u u2 on o.id_u2=u2.id
where o.id_u=3

select g.name gname,u1.name u1name,u2.name u2name
from o,g,u u1,u u2
where o.id_g=g.id and o.id_u1=u1.id and o.id_u2=u2.id and o.id_u=3

[日总是我哥]

不好意思~我今天没时间了,要是明天上班之前还没有正确答案的话,
我再来吧~~