I looked that up and IN is an OR ... correct ? Would be like saying: Show me the records where departmentid = 142 OR departmentid = 368
I did however find this: select * from departmentuser r1, departmentuser r2 where r1.userid=r2.userid and r1.departmentid=368 and r2.departmentid=142; Thanks for the help! PS Though my searching i still have not found anything on IF statements in SQL... i'm sure there is some, i just can't find any examples. Anyone give me one or two? >>> Sinisa Milivojevic <[EMAIL PROTECTED]> 12/01/01 11:02am >>> >Corey Kaye writes: > Currently i'm selecting all the users with 368 and running through a loop and >checking to > see if the returned list of userid also have 142. This takes about 20sec as this is >a BIG list ! > Would this query do what you need ?? SELECT userid from departmentuser where departmentid IN (142,368); --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
