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
