Select Statement

[nerram]

Example Table:
Username Status StatusB
-------------------------------
joe O
kevin O V
peter R V
mary O
Fred R

I want to select all usernames where the status is equal to O and Status B is not equal to V. I bit confuse with how to do this.

 

[SequelChik]

hi, i think you should try;

Select Username
From (TableName)
WHERE Status="O"
AND StatusB NOT "V"

Hope it helps

 

[nerram]

That gives me a syntax error around the NOT, should it??

 

[SequelChik]

ermm... try
NOT statusB="V" instead of AND

x

 

[nerram]

Select Username
From (TableName)
WHERE Status="O"
AND NOT T.LStatus ="V"

This returns Paula but nothing else any reasons??
Example Table:

Username Status StatusB
-------------------------------
joe O
kevin O V
peter R V
mary O
Fred R
Paula O L

 

[SequelChik]

sorry mate, I'm only new to this

 

[swampBoogie]

Select Username
From TableName 
WHERE Status= 'O'
AND ( LStatus <> 'V' or Lstatus is null)