Loading

Join 2 tables without relationship in sql

Devendra Kumar

8y972SQL

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?

3 Replies

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