Where condition

[RKULKARNI4]

All,

   I have 2 condition mentioned below :

       List= 123 Year >=2016
       List= 456 Year >=2008

I need to include in where clause How it can be done please advise.

Regards

RK

[Steven_Haught]

Is List a Field or a data source? 

[RKULKARNI4]

its Data Source(QVD).

I mean to say i am looking like 

if List= 123  then Year >=2016 

and  if List= 456 then Year >=2008.

in where clause 

[sunny_talwar]

May be this

Where (List= 123  and Year >= 2016) or (List = 456 and Year >= 2008)

[Usama]

hi,

try this:

Where (List= 123 and Year >= 2016) or/and (List = 456 and Year >= 2008)