Hi, I've been given a table to work with, and I'm not meant to change it:
------------------------------------- | TABLE_NAME | TBL_IDX | KEYW_ID | ------------------------------------- | PROPERTIES | 108 | 16 | ------------------------------------- | PROPERTIES | 119 | 16 | ------------------------------------- | PROPERTIES | 108 | 62 | ------------------------------------- | PROPERTIES | 119 | 16 | ------------------------------------- | PROPERTIES | 135 | 16 | ------------------------------------- | PROPERTIES | 135 | 17 | ------------------------------------- How do I select out and filter only rows that match both 16 and 62 in the KEYW_ID col? IE. The query would return only 119 and 108? Any help much appreciated Mumba. ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
