Joining Query

Hi

I wonder if anyone can help.

I have a table called lookup l and 2 tables called Event e and Staff s

I need to display the description of a field on the event and also a field on the staff tables. The only way to display the descriptions is to join it to the lookup table and choose the field l.description.

How can i do a double join on one table?

I have written the following on the seperate tables but i need to know how to join them together to display both descriptions.

inner join lookup l on event_type e = l.code_type
where l.code_type = '2'

inner join lookup l on s.team = l.code_type
where l.code_type = '196'


Any ideas please?

Many thanks

Richard