What's difference between the follwing INNER JOIN syntax

[Former Member]

Case1>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

SELECT C~WERKS " Plant

C~MATNR " Material

C~EKGRP " Purchasing group

C~DISPR " MRP Profile

A~BRGEW " Gross weight

C~DISMM " MRP type

C~DISLS " Lot size

D~BERID " MRP area

D~DISMM " MRP area MRP type

D~DISLS " MRP area Lot size

D~SOBSL " MRP area special procurement

W~STPRS " Standard price

INTO TABLE TAB_DATA

FROM ( ( ( MARC AS C

INNER JOIN MARA AS A ON C_{MATNR = A}MATNR )

INNER JOIN MBEW AS W ON C_{MATNR = W}MATNR )

INNER JOIN MDMA AS D ON C_{MATNR = D}MATNR )

WHERE C~WERKS = P_WERKS " Plant

AND C~MATNR IN S_MATNR " Material

AND C~DISPR IN S_DISPR " MRP profile

AND C~EKGRP IN S_EKGRP. " Purchasing group

Case2>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

SELECT C~WERKS " Plant

C~MATNR " Material

C~EKGRP " Purchasing group

C~DISPR " MRP Profile

A~BRGEW " Gross weight

C~DISMM " MRP type

C~DISLS " Lot size

D~BERID " MRP area

D~DISMM " MRP area MRP type

D~DISLS " MRP area Lot size

D~SOBSL " MRP area special procurement

W~STPRS " Standard price

INTO TABLE TAB_DATA

FROM MARC AS C

INNER JOIN MARA AS A ON C_{MATNR = A}MATNR

INNER JOIN MBEW AS W ON C_{MATNR = W}MATNR

INNER JOIN MDMA AS D ON C_{MATNR = D}MATNR

WHERE C~WERKS = P_WERKS " Plant

AND C~MATNR IN S_MATNR " Material

AND C~DISPR IN S_DISPR " MRP profile

AND C~EKGRP IN S_EKGRP. " Purchasing group

[christian_wohlfahrt]

Hi!

My guess: nothing at all. The execution by the database will anyway be independent of your way of describing the statement, e.g. you can't force the use of an index (in open SQL).

So the brackets are only for the reader of the source code.

Regards,

Christian

[Former Member]

Hi Xin,

Christian is right, there is no difference in the execution of the two INNER JOIN queries.

Regards

Nishant

[Former Member]

Thanks very much.

[Former Member]

Hi Xin,

Please close the thread if answered.

Regards

Nishant

[Former Member]

hi Xin,

Message was edited by:

Naresh Reddy