Simple query on two columns

[peterneve]

Hi guys,

This should be a really simple problem.

I have a two column table set-up as follows.

w_id | file
123  | 100
234  | 101
123  | 102
456  | 100
678  | 104
678  | 100

What I want to to select the file that has w_id 123 AND w_id 678.

select * from table where w_id=123 AND w_id=678 doesn't work as no row meets such conditions, select * from table where w_id=123 OR w_id=678 doesn't work because severals files meet that condition.

Does anyone have any ideas.

Thanks

 

[audiopro]

Use OR not AND.

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Sorry I hit submit
There can never be files which have 2 w_id numbers.
The OR statement meets your criteria.

Keith

http://www.studiosoft.co.uk

 

[peterneve]

If I use OR then I get files 100,102,104

 

[swampBoogie]

select file
from t
where w_id in (123,678)
group by file
having count(*) = 2