Forum Discussion

Leeeeeevin's avatar
Leeeeeevin
New Member
5 years ago
Solved

SAP Business One Query

Hello,   i have a problem with a SQL-Query from SAP Business one.    I have 4 tables:    ORDR - This is the sales order table RDR1 - These are the sales order lines    ODLN - This is the del...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Leeeeeevin ,

     

    Does the red code mean that left outer join two tables based on three columns?

    If so, hold "Ctrl" and select matching columns one by one like so:

     

    If this is not what you want, please provide more details.

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

  • Leeeeeevin's avatar
    Leeeeeevin
    5 years ago

    Hey Icey, 

     

    sometimes the solution is easier than you think ğŸ˜…. Thank you very much! 

     

    I also found another option to put the SQL-Query in PowerBi: 

     

    Maybe it will help someone who has the same problem

     

    Best regards and thank you!

    Levin

Leeeeeevin's avatar
Leeeeeevin
New Member
5 years ago

Hey Icey, 

 

sometimes the solution is easier than you think ğŸ˜…. Thank you very much! 

 

I also found another option to put the SQL-Query in PowerBi: 

 

Maybe it will help someone who has the same problem

 

Best regards and thank you!

Levin

Icey's avatar
Icey
Community Support
5 years ago

Hi Leeeeeevin ,

 

Thanks for sharing another solution!😉 You can also accept your reply as a solution, too. Your contribution is highly appreciated.

 

 

Best Regards,

Icey