Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
try this
where match(MarketID,'04' ,'105', '108')
or
where MarketID IN ('04' ,'105', '108')
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.
it shud work
Hi Stephen,
Both the solutions mentioned below should work
Regards
KC