How to join two tables and display the tables

Mekalamani V

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham K10y ago
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 V10y ago
I have Job No field Only in second table
Rajeesh Menoth10y ago
Hi,

Try this..

Select * from table1 FULL OUTER JOIN table2 on table1.Job No = table2.Job No
Gowtham K10y ago
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 V10y ago
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 Menoth10y ago
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 Surwase10y ago
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.item_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.

How to join two tables and display the tables

Accept the answer if it's help you.