How can I join two tables looking like this?

Table 1:
+----+-------+-------+
| Id |  Name | Score |
+----+-------+-------+

Table 2:
+----+-------+-------+-------+
| Id |  Name | Score | Info  |
+----+-------+-------+-------+

To get output table like this:

Table 2:
+----+-------+-------+---------+
| Id |  Name | Score | Info    |
+----+-------+-------+---------+
| ... table 1 and table 2 rows |
| ...                          |
+----+-------+-------+---------+



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to