Return rows where no matching ID exists 1

[hapax]

I have the following query:

Select *
FROM Unit u
inner join Event ev on
ev.UnitId = u.UnitId

But what I really want is something that does the opposite - returns all the records where no ev.UnitId exists for a given u.UnitId. How do I do that?

 

[markros]

Select *
FROM Unit u
LEFT join Event ev on
    ev.UnitId = u.UnitId
where ev.UnitID IS NULL