present2002
Programmer
Hello Everybody!
I have three tables:-
1. Cust [this table has customer address]
2. Cust_ORD [this table records customer's orders, and has Cust_ord_number as key field]
2. Alt_addr [this table has Latest customer's address, or he is requesting to receive his merchandise at this address, and has Cust_ord_number as key field]
Now I want to pull the address from Alt_addr table, if there is a customer_order_number in it, that matches with Cust_Ord_number that is present in Cust_ord table.
I have three tables:-
1. Cust [this table has customer address]
2. Cust_ORD [this table records customer's orders, and has Cust_ord_number as key field]
2. Alt_addr [this table has Latest customer's address, or he is requesting to receive his merchandise at this address, and has Cust_ord_number as key field]
Now I want to pull the address from Alt_addr table, if there is a customer_order_number in it, that matches with Cust_Ord_number that is present in Cust_ord table.