2. Data Enrichment [LEFT] :- ( When you needed a little bit of information from a reference table . then you use the join it to the master table . [MASTER TABLE + REFERENCE TABLE] = [COMBINED TABLE ...
below is a use demo: Connect to SQL Server, create a table dbo.OrderDetail, and run some sql on this table.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results