HowToDo INTERSECT query

[Glenn Barnard]

I need to perform the following SQL query against my db. Can anyone steer me 
in the right direction?

SELECT * FROM keywords WHERE keyword_id IN
(
SELECT keyword_id FROM listing_keywords WHERE listing_id=3289923 AND 
location_id=1007869
intersect
SELECT keyword_id FROM listing_keywords WHERE listing_id=3289923 AND 
location_id=20339
intersect
SELECT keyword_id FROM listing_keywords WHERE listing_id=3289923 AND 
location_id=20341
)

_________________________________________________________________
Tax headache? MSN Money provides relief with tax tips, tools, IRS forms and 
more! http://moneycentral.msn.com/tax/workshop/welcome.asp

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]