31-01-15, 08:39 PM
اهلا ، نعم يمكن عمل ذلك باستخدام iif الشرطيه ، كما يلي :
كود :
Select ID,name,Cutomer_s1,Cutomer_s2,Cutomer_s3,Cutomer_s4,IIF (Cutomer_s1=1 and Cutomer_s2=1 and Cutomer_s3=1 and Cutomer_s4=1,'Its Same','Its Not Same') As Total From TABLE_Cutomers
