SQL JOIN: Display Records With or Without Match on The Other Table

There will be cases where you want to join two (2) table and display records that has match or even without match on the other table. Table ...