求高效sql写法，简单3库查询

[deadhorse]

三个库：
g:
ID
Name

u:
ID
Name

o:
ID_g
ID_u
...

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

[日总是我哥]

Sleect g.Name, u.Name
From o Inner Join g On o.ID_g=g.ID
Inner Join u On o.ID_u=u.ID

[OpenVMS]

select o.*,g.Name,U.Name
From o,u,g
where o.Id_g=g.ID and o.Id_u=u.ID and o.ID_u=3

[日总是我哥]

哦,
我那少了一句,
加上

Sleect g.Name, u.Name
From o Inner Join g On o.ID_g=g.ID
Inner Join u On o.ID_u=u.ID
Where O.ID_u = 3