sql question

katy kuzemsky katy at ociwen.com
Fri Dec 5 10:21:48 CST 2003


Hi,


(V4MD198)
I would like a precison about the "In" operator.
sql = select * from table where champ in (subquery) : that's ok


What is the correct syntax to use the "in" operator with several value?
(these values are not the result of a subquery)

a) sql = select * from table where champ in (value1, value2, etc)
b) sql = select * from table where champ in [value1, value2, etc]
c) not implemented in this version of v4md


Thanks in advance.


Best regards,
    Katy    
    katy at ociwen.com



More information about the Valentina mailing list