From: Jakob Braeuchi <[EMAIL PROTECTED]> Reply-To: "OJB Users List" <[EMAIL PROTECTED]> To: OJB Users List <[EMAIL PROTECTED]> Subject: Re: HowToDo INTERSECT query Date: Sun, 18 Apr 2004 22:23:55 +0200
hi glenn,
unfortunately the only solutions is to use a queryBySql or you do the intersect processing programmatically.
jakob
Glenn Barnard wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
