Database join questions

there are two tables in db

Book{
isbn integer, //primary key
title char(50),
publisher char(30),
year integer
}

Author{
isbn integer,  //foreign key 
name String,
rank integer,  // indicate whether it is author1, author2, author3,...,authorn
}

write a sql statement to output book in this way Title author1 author2 publisher, year.

The logic is selecting two records from Author table according to isbn then combine to the record in Book and output it. I think we can do it in MySQL?

THANKS.