Hello Everyone!!!
I have a table has a field that is called Detail_no.
In this table I have some detail_no's that have duplicates and that is fine because one stands for a shipped record and the other stands for a recieved record.
However, I need the detail_no's that do not have a duplicate.
(shipped but Not received or Received but not shipped )... I know that does not make sense but it happens.
I am trying to find the best or Fastest way to do this because I a dealing with a table that starts out with over 400,000 records and eventually comes down to maybe 600.
I don't know if there is a function to do this or not. But any help would be greatly appreciated.
Thanks in advance
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide
LeRoy Jackson