hi dan

thanx for the response. i did try with 'WHERE NOT EXISTS' but didn't
return any row. i am stumped now

thanx buddy
bala