Fetching records from 2 tables

2002-02-11 Thread mailkittu
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

Fetching records from 2 tables

2002-02-08 Thread mailkittu
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