Joins vs. Sub-Selects

Suppose we have these tables:

create table departments (

    dept_id int not null primary key auto_increment,     dept varchar(50) not null unique
);

create table employees (

    emp_id int not null primary key auto_increment,     name varchar(50) not null unique,     dept_id int not null,
    foreign key (dept_id) references departments (dept_id) );

create table websites (

    emp_id int not null primary key,
    url varchar(50) not null,
    foreign key (emp_id) references employees (emp_id) );

An employee belongs to exactly one department, but not all employees have a website.

Suppose I want to know the name, department and website of all employees. There are many ways to formulate this query in SQL. In particular, one possible query is this:

select name, dept, url

   from employees inner join departments

       on employees.dept_id = departments.dept_id
          left join websites
              on employees.emp_id = websites.emp_id;

Another possible one is this:

select name,

   (select dept from departments where dept_id = employees.dept_id) as dept,

   (select url from websites where emp_id = employees.emp_id) as url  from employees

Which of these two queries would execute faster?

Here are some sample data: