Avatar of Dovberman
Dovberman
Flag for United States of America

asked on 

Need Join syntax for displaying all rows from table1 and only related rows from table 2

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?

Thanks,
 
SQL

Avatar of undefined
Last Comment
Dovberman

8/22/2022 - Mon