Skip to Content
0
Former Member
Feb 12, 2007 at 09:25 AM

What's difference between the follwing INNER JOIN syntax

35 Views

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 CMATNR = AMATNR )

INNER JOIN MBEW AS W ON CMATNR = WMATNR )

INNER JOIN MDMA AS D ON CMATNR = DMATNR )

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 CMATNR = AMATNR

INNER JOIN MBEW AS W ON CMATNR = WMATNR

INNER JOIN MDMA AS D ON CMATNR = DMATNR

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