I need to create a query that displays all rows in the master table (Table.M). A secondary table (Table.S) contains additional values that must be appended if there is a match.
For example:
Table.M columns
PK, columns....
1, joe,33,44,
2, mary,12,89
3, mike,22,9
Table.S columns
1, JJ
3...