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

Gowtham K · Answer

Try this select t1.itemcodet1.itemNamet1.Quantityt2.JobNot2.itemCodet2.itemNamet2.Quantity from table1 as t1 right outer join table2 as t2 on t1.itemcode=t2.JobNo

Mekalamani V · Answer

I have Job No field Only in second table

Rajeesh Menoth · Answer

Hi Try this.. Select * from table1 FULL OUTER JOIN table2 on table1.Job No = table2. Job No

Gowtham K · Answer

Try this select t1.itemcodet1.itemNamet1.Quantityt2.JobNot2.itemCodet2.itemNamet2.Quantity from table1 as t1 right outer join table2 as t2 on t1.itemcode=t2.JobNo

Mekalamani V · Answer

Thanks for Your Reply If I run this query it display like this Item Code Item Name Quantity Job No Item Code Item Name Quantity 1 Item1 300 1 1 Item1 150 1 Item1 300 2 1 Item1 150 But I want like this Item Code Item Name Quantity Job No Item Code Item Name Quantity 1 Item1 300 1 1 Item1 150 2 1 Item1 150

Rajeesh Menoth · Answer

Hi Select * from table1 FULL OUTER JOIN table2 on table1.ItemCode = table2.ItemCode Reference : http://www.sql-join.com/ http://www.sqlbook.com/SQL/INNER-JOIN-37.aspx

Sandy Surwase · Answer

using Left Outer Join SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name ; below is your query. SELECT table1. Item_Code  table1.i tem_Name table1.Quantity table2 .Job No table2.Item Code table2.Item_Name table2.Quantity FROM table1 LEFT JOIN table2 ON table1 . Item_Code = table2 . Item_Code; ================================== Accept the answer if it's help you.

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