Qvd where clause

[stephenedberkg]

ID      marketID            marketDescription

1         101                          aaa

2         102                          bbb

3         103                         ccc

4         104                         ddd

5         105                         eee

7         106                         fff

8         107                         ggg

9         108                         hhh

i want to load the market id 104 ,105, 108 only

i tried in where clause

where MarketID=104 and MarketID = 105 and MarketID = 108

but its not working help me

[arulsettu]

try this

where match(MarketID,'04' ,'105', '108')

or

where MarketID IN ('04' ,'105', '108')

[tresesco · Accepted solution]

Logically it should be OR rather than AND. Try replacing and with or like:

where MarketID=104 or MarketID = 105 or MarketID = 108

There would be easier ways too.

[gautik92]

it shud work

[jyothish8807]

Hi Stephen,

Both the solutions mentioned below should work

Regards

KC