MySQL Lists: mysql: Confirmation of SELECT...IN syntax

List:	General Discussion	« Previous Message Next Message »
From:	Doug Beyer	Date:	January 15 2003 5:54pm
Subject:	Confirmation of SELECT...IN syntax
View as plain text

It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?

Example:

SELECT t1.* 
FROM table1 t1 
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )



Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
doug.beyer@stripped
SAS... The Power to Know

Thread
• Confirmation of SELECT...IN syntax	Doug Beyer	15 Jan
• Re: Confirmation of SELECT...IN syntax	Dan Nelson	15 Jan
• RE: Confirmation of SELECT...IN syntax	Geoffrey Hoffman	15 Jan
• Re: Confirmation of SELECT...IN syntax	Jeremy Zawodny	15 Jan
• Re: Confirmation of SELECT...IN syntax	Zak Greant	16 Jan