CODE EXAMPLE FOR SQL

SQL

select * 
from   toys
left   outer join bricks
on     toy_id = brick_id;