|
|
Posted by John Smith on 04/12/06 13:17
Howdy,
Is it okay to use a literal value with the IN clause. E.g.
SELECT somefield, anotherfield
.....
WHERE ...etc.
AND 1234 IN (SELECT userid FROM tblUsers)
I was told it wasn't valid, but I'm pretty sure it worked for me. Just
seeking clarification.
cheers,
Navigation:
[Reply to this message]
|