SQL INTERSECT with MySQL 5.x

Submitted by Jochus on Thu, 02/09/2010 - 00:56 | Posted in: Database
Database

Yesterday, I wanted to perform a SQL INTERSECT operation on a MySQL 5.x database. I'm pretty used to work with Oracle, and Oracle is totally familiar with this

( SELECT foo FROM bar1 )
INTERSECT
( SELECT foo FROM bar2 )

Unfortunately, MySQL doesn't know this syntax. This is my workaround:
SELECT foo
FROM bar1
WHERE foo IN ( SELECT foo FROM bar2 )

Add new comment

The content of this field is kept private and will not be shown publicly.
About text formats

Full HTML

  • Lines and paragraphs break automatically.
  • You can caption images (data-caption="Text"), but also videos, blockquotes, and so on.
  • Web page addresses and email addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <bash>, <cpp>, <css>, <html5>, <java>, <javascript>, <php>, <sql>, <xml>. The supported tag styles are: <foo>, [foo].
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.