Devendra Kumar

Devendra Kumar

  • NA
  • 500
  • 157.5k

Join 2 tables without relationship in sql

Sep 26 2018 8:53 AM
Hello all
I am having an Stock table and StoreInfo table 
 
 
Stock table has 92 rows whereas StoreInfo table contains 1 rows
 
I want to fetch the following from the StockTable
ItemCode, ItemName, SalesPrice
 
and from StoreInfo table fetch
StoreName
 
The output I want is
ItemCode, ItemName, SalesPrice, StoreName
 
I tried cross join but it produces double the data i.e 184 (double of 92)
 
How to get that? 

Answers (3)