MySQL Forums
Forum List  »  Newbie

Re: Subqueries and intersect
Posted by: Ramalingam Chelliah
Date: August 09, 2004 02:58AM

Hi ,
You can use an alternative way...

SELECT Title
FROM titles,words
WHERE titles.ID=words.ID
AND Word='word1' OR Word='word2' OR Word='word3' ;

You have to specify ID explicity since ID is ambiguous ( Both Tables)

Hope this helps.....

Regards,
Ram.


Options: ReplyQuote


Subject
Written By
Posted
August 06, 2004 12:13PM
Re: Subqueries and intersect
August 09, 2004 02:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.