Hello My Friends, I'm a new member in TechRepublic. I have a question, about SQL Script. I'm Using SQL Server 2008. I have one table, contain 3 Fields... It's ID,STATUS,JUDGE 1. ID -- AutoNumber 2. STATUS -- Only 3 Words... PASSED, HOLD, REJECTED 3. JUDGE -- BOOLEAN (TRUE/FALSE) I want to know the SQL Script, if i have two criteria to filter. 1. Show All records that STATUS IS NOT PASSED 2. Show All records that STATUS IS PASSED AND JUDGE IS TRUE. SQL Script for No. 1: SELECT * FROM TableName WHERE Status<>'PASSED' SQL Script for No. 2: SELECT * FROM TableName WHERE Status='PASSED' AND Judge=TRUE How to combine the two scripts above into one script...??? Need help and advice. Regards, Fauzan