SELECT da.account_name, da.account_id, da.status, da.manager_firstname,
dap.live_password_change, dap.dev_password_change FROM dba_account da INNER JOIN
dba_account_password dap ON da.account_id = dap.account_id

SELECT da.account_name,
    da.account_id,
    da.status,
    da.manager_firstname,
    dap.live_password_change,
    dap.dev_password_change
FROM dba_account da
LEFT JOIN dba_account_password dap
    ON da.account_id = dap.account_id

SELECT da.account_name, da.account_id, da.status, da.manager_firstname,
dap.live_password_change, dap.dev_password_change FROM dba_account da LEFT JOIN
dba_account_password dap ON da.account_id = dap.account_id

table 1
userid  username
1        ABC
2        PQR
3        DEF
table2
userid  userRole
1       ACCOUNTANT
2       HO

RESULT OF LEFT JOIN :-

 left join on table1.userid=table2.userid
    userid   username  userrole
    1        ABC        ACCOUNTANT
    2        PQR        HO
    3        DEF

**