Querry giving incorrect result

Big problem here that is getting me frustrated
i have TABLE A and TABEL B
TABLE A TABLE B
ID DATA ID (FK to TABLE A) DATA
100001 = 100001
| |
101000 101000
So basically Table B's ID is identical with Table A since
it is simply a FK to A's ID
when i do a querry in an infinate loop
IF TABLE A's ID
is not in TABLE B's ID
Then insert an entry in BADDATA table.
Supposinly since talbe A and B's id is the same thing, i
should not be able to catch anything in the BADDATA
table..
HOWEVER what i end up with is after i loop the querry for
like an hour or 2 , i will start seeing some entry in the
BADDATA Table where the ID listed is less then
100001 which this ID does NOT exist since the ID started
FROM 100001.
please if anyone can give me some idea here about what
went wrong i would be VERY gratefull
hi simon,
you can do this with the help of INSERT INTO...SELECT syntax.
ex:
insert into baddata (col1,col2,col3)
select col1, col2, col3
from tablea
where not exists
(select * from tableb
where tablea.id = tableb.id)
Vishal
vgparkar@.yahoo.co.in
sql