Select All using SQL subquery
<p>I have two tables like this</p>

<pre><code>create table department(
Dno int primary key,
name varchar(50) not null
)


create table employee(
empid int primary key,
name varchar(50) not null,
sal decimal(7,2) not null,
dno int foreign key references department(Dno))
</code></pre>

<p>I want to get the same result of the following query using a SQL subquery.</p>

<pre><code>SELECT e.Name, e.Sal, d.Dno, d.Name
FROM Employee e,
     Department d
WHERE e.Dno = d.Dno
  AND e.name = 'aa'
</code></pre>

<p>Following is what I tried.</p>

<pre><code>SELECT Name, Sal
FROM Employee
WHERE Name= 'aa' AND Dno IN
    (SELECT Dno, name
     FROM Department) 
</code></pre>

<p>This gives following error.</p>

<blockquote>
  <p>Only one expression can be specified in the select list when the
  subquery is not introduced with EXISTS.</p>
</blockquote>