获取字段最大数 mysql_mysql-从表中获取字段x的值最大的行

我在mysql数据库中有两个表myTable和myTable2：

CREATE TABLE myTable (

id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

number INT,

version INT,

date DATE

) ENGINE MyISAM;

INSERT INTO myTable

(`id`, `number`, `version`, `date`)

VALUES

(1, '123', '1', '2016-01-12'),

(2, '123', '2', '2016-01-13'),

(3, '124', '1', '2016-01-14'),

(4, '124', '2', '2016-01-15'),

(5, '124', '3', '2016-01-16'),

(6, '125', '1', '2016-01-17')

;

CREATE TABLE myTable2 (

id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

myTable_id INT

) ENGINE MyISAM;

INSERT INTO myTable2

(`id`, `myTable_id`)

VALUES

(1, 1),

(2, 1),

(3, 2),

(4, 2),

(5, 3),

(6, 3),

(7, 4),

(8, 4),

(9, 4),

(10, 5),

(11, 6)

;

字段myTable2.myTable_id是myTable.Id的外键.

我想从myTable中获取所有行,其中myTable2.myTable_id = myTable.Id,而myTable中字段版本的值是myTable中字段编号的每个对应值的最大值.

我尝试过这样的事情：

SELECT

*

FROM

myTable,

myTable2

WHERE

myTable.version = (SELECT MAX(myTable.version) FROM myTable)

但是上面的查询没有返回正确的数据.正确的查询应输出以下内容：

Id number version date

2 123 2 2016-01-13

5 124 3 2016-01-16

6 125 1 2016-01-17

请帮忙！