NoBill Activity 0 xyz 0 xyz 1 Cancelled 1 ABC 1 Cancelled
NoBill Activity 0 xyz 0 xyz 1 Cancelled 1 Cancelled
SELECT * FROM CountySOAPNote WHERE NoBill=1 UNION ALL SELECT * FROM CountySOAPNote WHERE NoBill=0 AND Activity LIKE '%cancelled%'
SELECT * FROM CountySOAPNote WHERE NoBill=0 OR ( NoBill=1 AND Activity LIKE '%cancelled%' )
SELECT * FROM TABLE WHERE NOT (NOBILL = 1 AND ACTIVITY = 'ABC')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)