I have an issue I am related to JOINING table. Currently, I have two table I am try to JOIN but cannot achieve outcome I would like. Ultimately, I want to create a table that contains everything from Table 1 and Talbe 2 in the example attached. In the end, if a PROVIDER in Table 2 only performs service 1,2,3 and 5, I want the Final Table to contain all Services from 1 - 6 eventhough the PROVIDER didn;t have any data in Table 2. Is that possible? If so, how would accomplish it? See examples attached.
