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]