Sql Help Experts - Sql Server 2008

[ranjith23]

Hi All,

 

Use your own tables for below SQL. 

Complete RE-WRITE kakunda, koncham tweat chesi solution cheppandi.

 

SQL:

select *

 

  from TABLE1 A left join TABLE2 B on A.ID = B.ID  

  , TABLE3 C left join TABLE4 D on C.CUST = D.CUST

  left join TABLE2 B on C.ID = B.ID

 

Error:

Msg 1011, Level 16, State 1, Line 1

The correlation name 'B' is specified multiple times in a FROM clause.

 

 

Thanks in advance

 

 

 

[Sambadu]

select *

 

  from TABLE1 A 

  left join TABLE2 B on A.ID = B.ID  

  left join TABLE3 C on ?=?

  left join TABLE4 D on C.CUST = D.CUST

  left join TABLE2 E on C.ID = E.ID

 

 

 

Table2 ni 2 places lo use cheshi ..same alias ivaddu ani na guess!

[mtkr]

Yup... same alias ivvakudadhu tbl names ki...
n aa tbl 3 ni use chesinappudu comma(,) endhii!???

[ranjith23]

 

select *

 

  from TABLE1 A 

  left join TABLE2 B on A.ID = B.ID  

  left join TABLE3 C on ?=?

  left join TABLE4 D on C.CUST = D.CUST

  left join TABLE2 E on C.ID = E.ID

 

 

 

Table2 ni 2 places lo use cheshi ..same alias ivaddu ani na guess!

 

Bhaya in this scnerio, TABLE A ki anni tables  LEFT JOIN avuthunnate..Asalu TABLE A left join C & D meda ledhu..

[lbs]

Nuvu crazy ga Sql server and Oracle mix chesi rastunnav

[lbs]

A ki c ki join ledu ne initial query lo

[ranjith23]

Yup... same alias ivvakudadhu tbl names ki...
n aa tbl 3 ni use chesinappudu comma(,) endhii!???

1. TABLE A left join TABLE B on A.ID = B.ID

2. TABLE C left join TABLE D on C.CUST = D.CUST

3. TABLE C left join TABLE B on C.ID = B.ID

 

Edhi bhayya requirement chepalli ante..

[Sambadu]

Bhaya in this scnerio, TABLE A ki anni tables  LEFT JOIN avuthunnate..Asalu TABLE A left join C & D meda ledhu..

 oh sami.. nenu rasi di ela work avutadi ante.. 

 

A and b  left join ayaka vachina result  X anuko .. X tho C table left join avutundhi... vachina result y  anuko..

 

 

Y tho D ala...... 

[lbs]

1. TABLE A left join TABLE B on A.ID = B.ID
2. TABLE C left join TABLE D on C.CUST = D.CUST
3. TABLE C left join TABLE B on C.ID = B.ID

Edhi bhayya requirement chepalli ante..

A ki C ki join leda

[ranjith23]

Nuvu crazy ga Sql server and Oracle mix chesi rastunnav

Bhaya correct SQL develop chesi cheppandi in SQL server..

[ranjith23]

A ki C ki join leda

Yes..A and C ki join ledhu..

[mtkr]

1. TABLE A left join TABLE B on A.ID = B.ID
2. TABLE C left join TABLE D on C.CUST = D.CUST
3. TABLE C left join TABLE B on C.ID = B.ID

Edhi bhayya requirement chepalli ante..

dude ee conditions tho relation ela form chesthavv...

[ranjith23]

 oh sami.. nenu rasi di ela work avutadi ante.. 

 

A and b  left join ayaka vachina result  X anuko .. X tho C table left join avutundhi... vachina result y  anuko..

 

 

Y tho D ala...... 

A and C ki join ledhu kabbati..you mean to say below SQL is correct?

 

select *

 

  from TABLE1 A 

  left join TABLE2 B on A.ID = B.ID  

  left join TABLE4 D on C.CUST = D.CUST

  left join TABLE2 E on C.ID = E.ID

[mtkr]

inka anni separate joins n independent ante union use cheii

[Sambadu]

1. TABLE A left join TABLE B on A.ID = B.ID

2. TABLE C left join TABLE D on C.CUST = D.CUST

3. TABLE C left join TABLE B on C.ID = B.ID

 

Edhi bhayya requirement chepalli ante..

1. TABLE A left join TABLE B on A.ID = B.ID   ---- B ekkada use lekapothe......... y u r joining.. 

2. TABLE C left join TABLE D on C.CUST = D.CUST

3. TABLE C left join TABLE B on C.ID = B.ID -- bcoz u r using  Here...... Then again top enduku ani