Reputation: 67
I have two tables that don't have any relationship, I want to create a view that has a new Key
column that can be used.
StoreTable
:
StoreID StoreName
---------- -------------
1 Store1
2 Store2
3 Store3
StoreStageTable
:
StageID StageDesc
---------- -------------
1 Pre
2 WorkInProgress
3 Completed
Expected results would be for each StoreName
will be combined with each row from the StoreStageTable
.
So Store1
will have Store1_Pre
and Store1_WorkInProgress
and Store1_Completed
.
How can I do that?
Upvotes: 0
Views: 49