Re: Simple Select Statement
Mike Herber wrote:
> "SELECT * FROM login WHERE (Email = '$email') ORDER BY ID DESC";
>
> Works great but I need to add " WHERE Crsnum != 1,3,6,9,19 " so these crsnums are omited from
> the select.
WHERE Email = '$email' AND Crsnum NOT IN (1, 3, 6, 9, 19) ORDER BY ...
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: Simple Select Statement
July 19, 2005 12:40AM
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.