Your #1 source for SAP Business One tutorial videos
Business One has updated to 9.0! Videos focusing on new features and changes are coming!
New videos uploaded covering Alerts and A/R!
Business One Training: Now with over 275 videos!
Welcome to the new Business One Training site! Please let us know if you encounter any issues.

Left Outer Joins Demonstration

Thu, 02/14/2013 - 16:39 -- admin

SAP Business One is built on a SQL Server database and can be queried to get relevant information quickly and easily. In this training video we will look at a left outer join situation for stitching multiple tables together. We also address the situation where we may have holes in one table's data but still want all scenarios displayed. (I apologize ahead of time, this video is a little more intermediate and I am working on a follow-up that will be easier to follow)