help with a query
Posted by:
Keith
Date: March 16, 2005 09:36AM
I need help with a query .... I have a table that stores a client ID number (CID), type of client (Type, stored as a tinyint, alphabet containing 0,1), and a few other things that shouldn't need to be worried about. Now I need to first pull from the table clients with a type of 1, and clients with a type 0 but I don't want to pull the record for a client of type 0 if they have a type 1 also.
Probably too confusing .... thought I'd try.
Subject
Written By
Posted
help with a query
March 16, 2005 09:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.