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 ?