In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 ...

Is it possible to edit MySQL database table data with MySQL Administrator? ... write the appropriate SQL Insert or Update statement in the SQL frame and click the Execute button.