Select syntax help

[Jon7800]

Can someone tell me why these two statements are NOT returning the same results, shouldn't they be?

$sql = "SELECT *
From appleDesc
WHERE (Branch != \"$myBranch\" AND Department != \"$myDepartment\")

//////////////////////////////////////////////////////////////////////////////////////////////////////////

$sql = "SELECT *
From appleDesc
WHERE !(Branch = \"$myBranch\" AND Department = \"$myDepartment\")

Thank you in advance!
-Jon

[maxpup979]

Im reaching way back here to my college days (logic classes), but I do believe those should give different results. I could draw out the truth table I just did (and it may very well be wrong...its been a while), but !(X and Y)=F,T,T,T while !X AND !Y=F, F, F,T

[Jon7800]

Yep, you are right, i did the same thing (should have from the begining) and got the same results. Thanks much!
Jon