Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 in a list sql

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2013-08-06 : 10:50:36
I have to change one thing.

(SELECT LMLTPC, LMLOC1, LMLOC2, LMLOC3 FROM ASTDTA.ICLOCMLM WHERE
LMLTPC='PAL') t1

i want LMLTPC can also be = 'RAK'

something like LMLTTPC in 'PAL' 'RAK'

how to code that?

MuMu88
Aged Yak Warrior

549 Posts

Posted - 2013-08-06 : 11:00:55
[CODE]

(SELECT LMLTPC, LMLOC1, LMLOC2, LMLOC3 FROM ASTDTA.ICLOCMLM WHERE
LMLTPC in ('PAL', 'RAK') ) t1
[/CODE]
Go to Top of Page
   

- Advertisement -