This will be easy for alot of you out there...so please forgive my ignorance and don't laugh :o) ....I am using SQL 2000....what is the best way to query data when you have two fields in the same table with multiple values but only need specific information ? For example, I only need the qid values that equal m0440 and m0250 and their val values that = 1. I tried the following (but I get more data than needed): I need the two qid values that have the val 1 response -- both answers are a little different but start out the same.
select * from table1
where qid in ('m0250', '11m0440') and val like '1 -%'
Thanks for your help!