is there a NOT command for this, or how do I do this?

[jeff5656]

I want to exclude any $DB_TBLName3.id that equals 82.  How do I modify the following to exclude those cases (I only want 12 but don't want records with 82):

 

$sql = "Select * from $DB_TBLName, $DB_TBLName2, $DB_TBLName3  WHERE $DB_TBLName.id = $DB_TBLName2.case_id and $DB_TBLName3.id = '12' and $DB_TBLName.status = 'Closed' and $DB_TBLName.procedure_date  BETWEEN '2008-06-17' AND '2008-10-21'";

 

[prexep]

AND `$DB_TBLName3.id` != '82'

 

or <>

[discomatt]

AND `$DB_TBLName3.id` != '82'

 

or <>

 

You may want

 

AND `$DB_TBLName3`.`id` != '82'