need unique entries... distinct not working
I have a table with 3 columns. ex: column A, column B, column C.
Column B has a unique index. The problem is, even though there are no duplicates in column B, There may be 5000 exact matches in Column A. I can't use a unique on column A cause column A isn't immediately populated, and may be left blank for sometime. And column B reflects all the different pages(unique). (If I apply unique to Column A I lose half of what I got in Column B) I tried SELECT DISTINCT, but it has no effect at all. The results are the same whether I use it or not. Please help, I've been suffering with this delima for a while now. Thanks.