2011-02-21 ビューを作成する mysql 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 ;