Business One has updated to 9.0! Videos focusing on new features and changes are coming!
Left Outer Joins Demonstration
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)