Re: Combining columns coming from 2 tables

2010-01-06 Thread Antoni Aloy
2010/1/5 fredlab > Hey, > > My question is probably very simple. Below, my simplified model : > > I have a table of stock items in stock (item_code, item_title, > property1, property2, storeroom, quantity_available) > I have a table listing transaction of items (transaction_id, > item_code, trans

Combining columns coming from 2 tables

2010-01-05 Thread fredlab
Hey, My question is probably very simple. Below, my simplified model : I have a table of stock items in stock (item_code, item_title, property1, property2, storeroom, quantity_available) I have a table listing transaction of items (transaction_id, item_code, transaction_type, transaction_quantity