select where criteria is met and exclude certain entries

fr0s1yjack · #1 (**permalink**) 06-18-11, 13:36

hi,

whats wrong with this? :

Code:

SELECT `invoice`.`franchise_no`, 
       `invoice`.`invoice_date`, 
       `invoice`.`invoice_date_due`, 
       `invoice`.`invoice_net`, 
       `invoice`.`invoice_no`, 
       `invoice`.`order_no`
FROM `invoice` `invoice`
WHERE ( `invoice`.`invoice_net` < 130 )
AND invoice_net NOT IN (
SELECT `invoice`.`franchise_no`, 
       `invoice`.`invoice_date`, 
       `invoice`.`invoice_date_due`, 
       `invoice`.`invoice_net`, 
       `invoice`.`invoice_no`, 
       `invoice`.`order_no`
FROM `invoice` `invoice`
WHERE invoice_net = 70  )
 );

i need the records less than 130 but exclude any that are exactly 70!!

healdem · #2 (**permalink**) 06-18-11, 13:58

Code:

SELECT `invoice`.`franchise_no`, 
       `invoice`.`invoice_date`, 
       `invoice`.`invoice_date_due`, 
       `invoice`.`invoice_net`, 
       `invoice`.`invoice_no`, 
       `invoice`.`order_no`
FROM `invoice` `invoice`
WHERE ( `invoice`.`invoice_net` < 130  AND `invoice`.`invoice_net` != 70)

you may need to tinker with the not equals sign it could be <> 70

Internet Services

Web Development

Digital Marketing

Consumer Tech