Jag får följande felmeddelande, någon som har ngt tips?

[Microsoft][ODBC SQL Server Driver][SQL Server] All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists.

Tack

Du kan inte ha olika många fält i selectsatsen.

Funkar:
<code>
use northwind

Select firstname from employees
union
Select lastname from employees
<code>

Funkar inte:
<code>
use northwind

Select firstname, lastname from employees
union
Select lastname from employees
<code>

Danke....