Merge virtually two mysql tables

Is there a way to merge two tables in MySQL virtually so I could query and insert data? (which is basicly splitted)

exp.

table

• id
• active
• foo

table_meta

• table_id
• language
• text

What I'd like to do is using something like this instead of sql-join

INSERT INTO 开发者_如何学Pythontable_join SET active = 1, language = 'en';

---

Assuming you're on mySQL 5.1.x, here is a reference on what is allowed with regards to an insertable or updatable view.