ビューを作成する

CREATE VIEW v_tmp AS

 SELECT

  t_aaa.id AS aaa_id

 ,t_bbb.id AS bbb_id

 FROM t_aaa

 LEFT JOIN t_bbb

 ON t_aaa.id = t_bbb.id

;