求一SQL语句(20分)

F

foreachman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-08

• #1

请问怎么把这两句话连在一起呀，用left outer join
select c.ANT_Gain,d.AT_Unit_Type from RSBT_ANTFEED c,RSBT_ANTFEED_t d where c.GUID=d.GUID and
c.STATION_GUID= '34c7628c-836c-41d7-8681-2d4617fc5241'

select b.ET_EQU_NO, a.EQU_Model,a.EQU_AUTH,a.EQU_POW,a.EQU_PF,
a.EQU_MENU,a.EQU_Code from RSBT_EQU a ,RSBT_EQU_T b where a.guid=b.guid and a.station_guid='34c7628c-836c-41d7-8681-2d4617fc5241'

 

Y

yunxi126

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-08

• #2

select A.*,b.*(select c.ANT_Gain,d.AT_Unit_Type from RSBT_ANTFEED c,RSBT_ANTFEED_t d where c.GUID=d.GUID and
c.STATION_GUID= '34c7628c-836c-41d7-8681-2d4617fc5241')A
left outer join
(select b.ET_EQU_NO, a.EQU_Model,a.EQU_AUTH,a.EQU_POW,a.EQU_PF,
a.EQU_MENU,a.EQU_Code from RSBT_EQU a ,RSBT_EQU_T b where a.guid=b.guid and a.station_guid='34c7628c-836c-41d7-8681-2d4617fc5241'
) B
on A.關聯字段=B.關聯字段

 

Y

yunxi126

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-08

• #3

select A.*,b.* from(select c.ANT_Gain,d.AT_Unit_Type from RSBT_ANTFEED c,RSBT_ANTFEED_t d where c.GUID=d.GUID and
c.STATION_GUID= '34c7628c-836c-41d7-8681-2d4617fc5241')A
left outer join
(select b.ET_EQU_NO, a.EQU_Model,a.EQU_AUTH,a.EQU_POW,a.EQU_PF,
a.EQU_MENU,a.EQU_Code from RSBT_EQU a ,RSBT_EQU_T b where a.guid=b.guid and a.station_guid='34c7628c-836c-41d7-8681-2d4617fc5241'
) B
on A.關聯字段=B.關聯字段
少了個form

 

F

foreachman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-08

• #4

这样查出来还是不正确，因为有重复的数据

 

F

foreachman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-08

• #5

ding

 

D

duxing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-09

• #6

用distinct ~

 

S

sdnumen

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-09

• #7

有重复的用distinct

 

Y

yunxi126

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-10-09

• #8

應該是有重複字斷吧....你as一下別的字斷名吧. 要麼就別查有重複的字斷.