Re: TABLE - OR

2003-09-01 Thread Nishant
wow. yeah it works. Thanks a lot. -N. > On Mon, 01 Sep 2003 17:13:20 +0900 > Nishant <[EMAIL PROTECTED]> wrote: > > > I dont know why my brain stopped working :) > > > > I have two tables T1 and T2, both of which have a column : Seria

Re: TABLE - OR

2003-09-01 Thread Antony Dovgal
On Mon, 01 Sep 2003 17:13:20 +0900 Nishant <[EMAIL PROTECTED]> wrote: > I dont know why my brain stopped working :) > > I have two tables T1 and T2, both of which have a column : SerialNo > > Now I want to select those rows from T1 whose SerialNo is not present in > T2. > > This dont work: >