Joining tables in SQL has $3$ types. If we join $2$ tables, A and B$,$ will guarantee collecting all records in table $B.$

B left join A

B inner join A

A left join B

A center join B