CREATE VIEW myview AS
SELECT a.field1, a.field2, a.field3, b.*
FROM tablea a LEFT JOIN tableb b USING (id);