Mysql select

Discussion in 'Programming/Scripts' started by bernholdt, Jul 31, 2009.

  1. bernholdt

    bernholdt Member

    Hi all
    hope someone can help me?
    I have a select statement need to look something like this

    select * from 'client' WEHRE 'row1' >= '1' EXEPT WHERE 'date' = 'value AND 'row1' = 'value2'

    What i need it to do is:
    I need to show all clients where row 1 = 1 or greater, but i also need to show clients from max 6 month ago where client row = Zero

    Any idea ?
     

Share This Page