From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use INNER JOIN for two tables

Use INNER JOIN for two tables - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Use INNER JOIN for two tables

“

- [Narrator] After looking at the report we've generated and showing all those overdue orders. The production manager wants to prioritize orders, but we don't have an inventory. We'll need inventory numbers which are in the items master table OITM. We're going to have to join the two tables we have together. There's two ways to join tables together. If you know you need that second table when you make your original query, you can specify it in the query generator and the join will be constructed for you if there are direct links. So go ahead and open up Query Generator and add OWOR, which is the one we've been working with for the production report. Hit tab. And the item master data is OITM. So O-I-T-M and hit tab. Then you'll see that this one doesn't work, instead we just have a comma between these two. It's got different table names, T0 and T1, but it doesn't actually work. Things that will work tend to be things…

Contents