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.itemcode,t1.itemName,t1.Quantity,t2.JobNo,t2.itemCode,t2.itemName,t2.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.itemcode,t1.itemName,t1.Quantity,t2.JobNo,t2.itemCode,t2.itemName,t2.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

How to join two tables and display the tables

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)