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?