CODEWITHSUNDEEP
sqlsql-server-2008sql-server-2005
Venaikat
Venaikat

Reputation: 197

getting different column names from 2 tables in sql server

I have Item and Sales tables with different columns like,

Item 

ItemName                        
Itemcost                       
ItemQty

Sales

 SalesName     
 SalesDate  
 SalesQty

In the above tables there is not common column,but i need to get output as 

ItemName,ItemCost,SalesName,SalesDate.

I tried with union,

select ItemName,ItemCost from Item
union     
select SalesName,SalesDate from Sales

but am getting only 1 table columns like ItemName,ItemCost

Please help me on this issue

Thanks In Advance

Venkat.

Upvotes: 4

Views: 2142

Answers (2)

user2001117
user2001117

Reputation: 3777

Use the below query :

This will join every row in table1 with table2 (the Cartesian product) returning all columns.

Select im.ItemName, im.ItemCost, sl.SalesName,sl.SalesDate from Item as im, Sales as sl;

Upvotes: 1

Dipali Nagrale
Dipali Nagrale

Reputation: 520

Use below sql query :

select i.ItemName, i.ItemCost, s.SalesName, s.SalesDate 
from Item as i, Sales as s;

Upvotes: 5

Related Questions