Re: id <> '2'

mike (hillmw_at_charter.net) wrote:
: I guess I could use a join like:

: select *
: from mytable
: where id<>'2'
: union
: select *
: from mytable
: where id is null

First, that is not a join, it's a union.

Second, yes I guess you could use that, but it is complete over kill. Read up on the syntax and capabilities of expressions in the WHERE clause. Things like "i=1 and j=2" are standard logic expressions and work in SQL as in most other computer languages.

Third, 2 is a number, etc etc, (but someone mentioned that elsewhere).

--

This programmer available for rent.