listed. There are about 20K rows in this table. What I need to is join
the ALPHA table to retrieve CUSTOMER_ID that each email address
identified with.
I can write a script that loops over all the address and an insert to a
new table with the found customer_id, but that just doesn't seem right.
20K database reads and 20K database writes, seems a little bit of
overkill for matching up a email addresses with an ID.
I also could also do something along this method which is probably the
better solution:
CREATE TABLE NEWTABLE AS (SELECT A.CUSTOMER_ID, B.EMAIL FROM TABLE A
INNER JOIN TABLE B ON B.EMAIL = A.EMAIL)
I am looking for a couple of other suggestions before I write this
module.
Thx!
-----------------------
Ricky Fritzsching
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
