if you have an ms. windows machine for a front end, i recommend that you download corereader from http://CoreReader.com/ . ( it's free. ) it does point&click queries, so you can quickly experiment with them until you get what you want.
it installs at the novice level, so set it to the proficient skill level. in the where clause frame, you'll find drop-down lists for the selects. i believe that the one that you want is the "is in" which will produce the ansi92 "in" select for you. when it's returning what you want, open the sql frame, which will show you the sql statement that it built for you. (fair warning: not even corereader can make the data connection simple. ) > > Query ( that gets past the anti spam ) > > Question is...... > > I have a select where I want to get ID 15 && id 25 > > Can I do something like WHERE ID = 15,25 > > Or do I have to do WHERE ID = 15 && ID = 25 > > --------------------------------------------------------- > Chris Kay > Techex Communications > Website: www.techex.com.au Email: [EMAIL PROTECTED] > Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 > --------------------------------------------------------- > > -- John Ragan [EMAIL PROTECTED] 501-228-0317 http://www.CoreReader.com/ --------------------------------------------------------------------- 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