These are the 2 tables.
Tech\_data: 

```
Id Tech Agent1_id Agent2_ID
1  JAVA   1           2   
2  SQL    3           4

```

Agent\_table

```
Id Name
1  Mike
2  John
3  Jim
4  Baron

```

I need to write a query to bring the below output

```
TECH_ID   Tech  Agent1_Name Agent2_Name
1         Java    Mike       John
2         SQL     Jim        Baron

```

I wrote LEFT OUTER JOIN ON tech\_id=agent1\_id, but i do not know how to join 2 ids in ON condition.