mardi 29 décembre 2015

How to write where clause with combination of AND & OR

I want to use query like below

( type = 1 OR type = 3 ) AND number = +9199123456

or below one

( type = 1 AND number = +9199123456) OR ( type = 3 AND number = +9199123456)

In my code I wrote like

whereClause = CallLog.Calls.NUMBER + " = " + phNO + " AND ("+CallLog.Calls.TYPE + " = " + CallLog.Calls.INCOMING_TYPE + " OR " + CallLog.Calls.TYPE + " = " + CallLog.Calls.MISSED_TYPE+")";

Thank you in advance. please help me .

Aucun commentaire:

Enregistrer un commentaire