Query Question
From: Scott T Johnson <sarek_at_cais2.cais.com>
Date: 29 Jul 1994 22:48:52 GMT
Message-ID: <31c10k$4sa_at_sun.cais.com>
Date: 29 Jul 1994 22:48:52 GMT
Message-ID: <31c10k$4sa_at_sun.cais.com>
I have a preformance problem. I have two tables: A & B. I need to update
A from B based on whats already in A.
A B
2 1
4 2
3
4
5
I need table A to have the same values as B. Values 2 and 4 cannot be deleted or duplicated. I tried: INSERT INTO A SELECT C1 FROM B WHERE C1 NOT IN (SELECT C1 FROM B); This takes forever!! Help!!
Thanks,
Scott
- -----