give a list over all fields that exist in table b but not in table
a
Hope this is useful for you.
Terje K
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:32 AM
> To: [EMAIL PROTECTED]
> Subject: Fetching record
hi List
The problem is like this
There are two Tables A and B.
what i want to do is find out all the records where a.id != b.id
Both tables have close to 1 records. so for every a.id it has to
check table b 1 times and that is what is creating problems.
bcos this query takes hell lot
give a list over all fields that exist in table b but not in table
a
Hope this is useful for you.
Terje K
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:32 AM
> To: [EMAIL PROTECTED]
> Subject: Fetching record
hi List
The problem is like this
There are two Tables A and B.
what i want to do is find out all the records where a.id != b.id
Both tables have close to 1 records. so for every a.id it has to
check table b 1 times and that is what is creating problems.
bcos this query takes hell lot