What is difference between inner join and cross join?

952

SELECT A~FTRMI A~AUFNR B~MATNR D~MAKTX B~PSMNG B~WEMNG C~MTART E~CHARG C~MATKL C~SPART R~BWART R~CHARG R~MATNR E~BWART R~BDMNG INTO TABLE ITAB FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR * INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK = A1~WERKS INNER JOIN MARA AS C ON B~MATNR = C~MATNR INNER JOIN MAKT AS D ON C~MATNR = D~MATNR INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR = E~AUFNR AND B~DWERK = E~WERKS INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR = R~AUFNR AND R~RSNUM = A~RSNUM AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART IN S_TYPE AND C~MATKL = 'T' AND R~BWART ='261' AND E~BWART = '101' AND R~XWAOK ='X' AND B~DWERK = '2000' AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND R~KZEAR = 'X' AND C~MATNR IN S_MATNR. This query gives repetative records from RESB.There must be some common field which i am not taking thats why its giving repetative records. If u find any solution pls lety me know ASAP. Thanks Swati Ghadge

3306

how to get no of items from from weblist?

1881

Can you please explain the difference between overloading and overriding?

1078

Explain SparkContext in Apache Spark?

321

How is technology significant in the field of mechanical engineering?

1138

Question on maha cement

724

In a class implementing an interface, can we change the value of any variable defined in the interface?

1067

What are the system requirements for drupal 7 and drupal 8?

129

Which up-selling techniques have you employed to your clients? : insurance cold calling

588

What do you mean by bootstrapping and how you will find the user data and meta data over the instances.

259

What will happen if boiler backfires?

1951

What is difference between path and classpath?

1142

Is c# code is managed or unmanaged code?

1008

i need a test plan for ORBITZ.com there is a "VACATION PACKAGES" section on the website.. i am a bit confused about how to create a test plan for that.

3119