I'm very much a noob when it comes to MySQL .. Historically I've only used it for storage. I need help.
I have a table: +--------------------+-----------------------+------+-----+---------+------- ---------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-----------------------+------+-----+---------+------- ---------+ | memberspecialty_id | int(10) unsigned | | PRI | NULL | auto_increment | | member_id | smallint(10) unsigned | | MUL | 0 | | | specialty_id | tinyint(3) unsigned | | MUL | 0 | | +--------------------+-----------------------+------+-----+---------+------- ---------+ How would I select all distinct member_id that have a specialty_id of 6 and 33? Thanks! ~ Mike ----- Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: <http://MikeZornek.com> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
