February 5th, 2013, 03:02 PM
Join Date: Feb 2013
Time spent in forums: 25 m 19 sec
Reputation Power: 0
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?