How to join two tables and display the tables

Question

Hi frds,

My table1 fields are 

Item Code	Item Name	Quantity
1	Item1	300

 

My table2 Fields are

Job No	Item Code	Item Name	Quantity
1	1	Item1	150
2	1	Item1	150

 

When i join this two table, the result will be

Item Code	Item Name	Quantity	Job No	Item Code	Item Name	Quantity
1	Item1	300	1	1	Item1	150
			2	1	Item1	150

like  this.I don't know how proceed this. any one guide me.

Thank You