Seems to me you should add another clause to this:

UPDATE Ticketing SET TicketPriceExVat =

(SELECT TicketPriceExVat FROM TempTicketing

WHERE TempTicketing.EventID = Ticketing .EventID

AND TicketPriceExVat IS NOT NULL)