Re: Why the "where NOT EXISTS" does not work?

Try
select a from A_Table
minus
select a from B_table

This will give you all a from A_table NOT in B_table

C Chang <cschang_at_maxinter.net> wrote:

>I have 2 tables say A_table, B_table. They both have some common
>columns. The A_Table has some rows that with the column not appearing
>in B_table. I tried to use following to find out what appears in
>A_talbe but not in B_table.
> select a
> from A_table
> where NOT EXISTS
> ( select a
> from B_table
> where ..);
>and it always return 0 row. What went wrong? Need Help Thanks.
>
>C Chang

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Oct 24 2001 - 11:00:36 CDT