Table 1 is the parent table. PK1 is primary key of the Table 1.
FK1 is the foreign key in Table 2
Table 1 and Table 2 are joined on PK1 = FK1
Table 2 does not have a row for each row of Table 1
I need to display values from all selected rows of Table 1 and values from Table2 only where there is a matching key.
What is the Join syntax?