Hi need help again..
I have an item master table as below
I Also have a rack table as below
there's no relation between those table so I try to put the row number for both. The scenario is the item will put on the rack table. and the result will be
RID Location item
R001 Store1 Shoes
R002 Store2 Jacket
It's only show data base on the rack data. I try to use the inner join but the result show several times as much the data of item master