how can this query be written without a UNION clause?

[yehong]

I have this query and I want to know if its possible to write it without a UNION clause.

select id from table_a
where
(name='Atlanta' And locations In ('1' ,'2','3') )
union
select id from table_a
where
(name='Los Angeles' And locations In ('11' ,'12','13')).

Basically I only want those ids who have records with name='Atlanta' and locations in 1,2,3 and name='Los Angeles' and locations in 11,12,13.

The above UNION query gives me the correct results but my requirement does not allow using a UNION clause. Thanks in advance.

 

[SQLDenis]

what happens when you do this

select id from table_a
where
((name='Atlanta' And locations In ('1' ,'2','3') )
OR
(name='Los Angeles' And locations In ('11' ,'12','13')))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[yehong]

I get more records than I should see. For example I have ID=1, that has Atlanta and 1,2,3 and Los Angeles and 11,12,13. If I use Or I am geeting ID 1 plus other ids who have Los Angeles and 11,12,13 only.

 

[yehong]

sorry. i noticed that you have used one extra () brackets to enclose whole Where clause. I tried with that and it seemed to bring back correct data. I am going to test more data with that. thanks