SQL Optimisation Tip

There is a saying 'There are many ways to skin a cat' this is rarely as true as it is with optimising SQL.