Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.ms-sqlserver | Notorious Rube Goldberg contraption | 19,505 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 17,770 of 19,505 |
| Plamen Ratchev to All |
| Re: overlap in where clause produces int |
| 03 Mar 10 22:48:01 |
28da6131 From: Plamen@SQLStudio.com The WHERE clause is used to specify predicates filtering the result set. It does not imply union operation. To accomplish what you want you have to use UNION ALL: SELECT id FROM @s WHERE id <= 3 UNION ALL SELECT id FROM @s WHERE id >= 2; -- Plamen Ratchev http://www.SQLStudio.com --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca