What's the difference between join and concatenate? Is this example OK? it's OK ib both ways?
Suppose i have 3 tables ALREADY created. Cust_Seller , Orders, Stock
Cust_Seller:
LOAD
Cust_ID,
Seller_ID,
Key
Orders:
LOAD
Order_ID,
Order_Articule
Order_Date,
Key;
Stock:
LOAD
Stock_ID
Order_ID,
Stock_Quantity,
Stock_Local;
What i want is to put in table "Cust_Seller", the STOCK_ID. so first i have to join ORDERS with Cust_Seller, put the Order_ID, and then join Stock with Cust_Seller, putting ONLY the Stock_ID (and relationing them with order_ID). Its OK????
Using join:
left join (Cust_Seller) // I only add Order_ID in Cust_sellers Table.. for those "Key" that matches?
load
Key,
Order_ID
Resident Orders;
left join (Cust_Seller) // I only add Stock_ID in Cust_Sellers Table.. for those orders that macthes the previous orders added??
load
Order_ID,
Stock_ID
Resident (Stock)
Its OK????
Using Concatenate
LOAD
Key
Resident Cust_Sellers
CONCATENATE // Here im adding all the orders_ID? I put distinct, in order to not aggregate same Keys as i had in the other table?
DISTINCT LOAD
Key
Order_ID
Resident Orders
LOAD
Order_ID
Resident Cust_Sellers
CONCATENATE // Here im adding all the Stock_ID? I put distinct, in order to not aggregate same orders as before...?
DISTINCT LOAD
Order_ID
Stock_ID
Resident Stock
Its OK???
Whats the difference between both?
If anyone can help me wi the 2 versions i woul appreciate a lot!
Yeah, i've got it.. i understand now the difference but don't know how to apply them when i have 3 tables like in this example, and i want to put "things" from table 1 to table 3 passing through table 2.
