Como realizar una operación INTERSECT con MySQL

Activado 7 Nov, 2011 Por Adolfo 27 Comentarios

Una consulta de tipo INTERSECT nos devuelve la intersección de dos consultas, es decir, los valores comunes a las dos consultas, y nos es útil para comprobar que valores cumplen con dos condiciones distintas. en MySQL esta función no existe, por lo que hemos tenido que buscar una solución alternativa.

La consulta original sería de la forma

  1. SELECT member_id, name FROM a 
  2. INTERSECT 
  3. SELECT member_id, name FROM b

Para solucionar esto lo que hacemos es realizar un INNER JOIN de las dos tablas, quedando una consulta de tipo

  1. SELECT a.member_id, a.name 
  3. USING (member_id, name)

con lo que resolvemos el problema.

Esta información la hemos obtenido a partir del blog Carsten's Random Ramblings.

Etiquetas: 
MySQL

Comentarios

domen (no verificado)

Mié, 20/06/2018 - 12:19

This is basic, but informative last day some one ask me about that thing so i will send that screen shot at custom dissertations writing so that they get help which he needed thanks.

Carolyn Short (no verificado)

Mar, 23/10/2018 - 12:27

It is a nice post.  gangstar vegas mod apk android  zombie tsunami mod apk latest version  cooking fever mod apk android

stellaeden (no verificado)

Dom, 04/11/2018 - 10:25

MySQL is a little, conservative database server perfect for little - and not all that little - applications. Notwithstanding supporting standard SQL (ANSI), it gathers on various stages and has multithreading capacities on Unix servers, which make for extraordinary execution. Jiu jitsu gi supplier

ninjadeden (no verificado)

Jue, 22/11/2018 - 03:11

am mereka, mencuci makeup dan menikmati matahari, lalink 5 distributor plat high tensile sm490ya distributor plat kapal distributor plat stainless ss304 distributor plat stainless ss310 distributor plat stainless ss316 distributor plat sumihard distributor round bar besi aisi 440s45c distributor round bar scm440 distributor steel rail distributor steel sheet pile jual astm a283 c undangan pernikahan kalender Jual besi hollow Jual besi hollow Toko besi siku Toko pipa besi baja sch 40 sch 80 undangan pernikahan bentuk tas Supplier Besi H beam Agen Wiremesh Besi baja Jual plat kapal besi baja Pabrik besi beton master steel ms Supplier besi hollow Supplier besi hollow Toko pipa besi baja sch 40 sch 80 Toko besi hollow undangan pernikahan ada fotonya Supplier Besi Beton Toko Wiremesh Besi baja Supplier plat kapal besi baja Pabrik besi beton ksty Toko besi hollow Toko besi hollow Toko Plat besi Toko besi beton Sni Ulir Polos undangan pernikahan aneh www.sentrabesibaja.com Jual Wiremesh Besi baja Toko plat kapal besi baja Pabrik besi beton krakatau steel Agen besi hollow Agen besi hollow Toko besi h beam Toko besi wf baja undangan pernikahan amplop Pabrik Welded Beam T beam King Queen Cross Castellated Beam Harga Wiremesh Besi baja Agen plat kapal besi baja Pabrik besi beton jcac Pabrik besi hollow Pabrik besi hollow Toko besi wf Toko besi unp undangan pernikahan batik Pabrik Bondek Cor Pabrik Wiremesh Besi baja Pabrik plat kapal besi baja Pabrik besi beton interworld steel is Distributor pipa besi Distributor pipa besi Toko wiremesh Toko besi siku undangan pernikahan murah Pabrik Atap Spandek Sni Distributor Besi Siku Baja

JeaShasia (no verificado)

Sáb, 29/12/2018 - 22:38

Stendra Purchase Next Day Delivery Discount Progesterone Hormone Replacement Amex do you need a prescription for propecia Viagra Pfizer 100mg Viagra Y Cialis Viagra Brand Vs Generic Cialis Ceguera generic viagra Thyroxine Finasteride Vendita Propecia Online Cialis Forma Farmaceutica Kamagra Online Flashback Buying Provera cialis from canada Cialis Tabletten Teilen Discount Erectile Dysfunction Drugs

Saben aquel que... (no verificado)

Vie, 05/04/2019 - 19:39

<p>&nbsp;</p><p>´dcfsdvjkdsjkdsjdnvsnvjkfsvsf&nbsp;</p>

AustRaf (no verificado)

Mié, 15/05/2019 - 06:30

Acheter Cialis Quebec viagra online prescription isotretinoin acutane pills no physician approval overseas Cialis Dolores Musculares Viagra Sans En Avoir Besoin

AustRaf (no verificado)

Dom, 09/06/2019 - 07:07

Progesterone Order Now Low Price With Free Shipping canadian pharmacy cialis Will Amoxicillin Heal Tooth Absess Secure Ordering Progesterone Amex Accepted Tablets

Randswoli (no verificado)

Sáb, 22/06/2019 - 09:34

Cialis 20 Mg Preiswert Cialis Tabs Sale Viagra Und Cialis Generika cialis without a doctor's prescription Cialis Corazon Prix Du Viagra Generique En Valence

Randswoli (no verificado)

Vie, 05/07/2019 - 05:56

Online Pharmacy Genuine Medications Disfunzione Erettile Cialis where to buy cialis online safely Nolvadex Over Counter Isotretinoin Isotret

Stepgroog (no verificado)

Vie, 12/07/2019 - 16:52

Viagra Generica Barata cialis price Purchase Levitra Professional Sinus Infection Zithromax

AustRaf (no verificado)

Dom, 14/07/2019 - 01:14

Biomox Amoxicillin Liquid Cialis 40 Mg Pills Generic Kamagra Gold 100mg Review cialis for sale Viagra Kaufen Online Apotheke Levitra Zutaten Amoxicillin Manufacture

Stepgroog (no verificado)

Lun, 22/07/2019 - 04:02

Viagra Gel Online Cialis Lilly Icos Tadalafil cialis without prescription Clonidine Overnight Where Can I Buy Isotretinoin Skin Health Low Price Mastercard

SMes (no verificado)

Dom, 07/01/2024 - 06:10

Life is what happens when you're busy making other plans. http://7d.tel/Qa4Wd4

YUMes (no verificado)

Dom, 07/01/2024 - 22:21

Hey, boo. http://7d.tel/bFMzWy

YUMes (no verificado)

Lun, 08/01/2024 - 05:20

Thanks for sharing! http://7d.tel/QdGWB6

RecyclingGuape (no verificado)

Jue, 11/01/2024 - 07:39

Copper scrap pricing http://7d.tel/pwrVN6

RecycleGuape (no verificado)

Vie, 12/01/2024 - 06:23

Copper scrap purchasing http://7d.tel/7zC3Mm

Aluminium Scrap Yard (no verificado)

Jue, 25/01/2024 - 14:31

Aluminum siding scrap http://7d.tel/JHhXFR

Aluminium Recycle (no verificado)

Vie, 26/01/2024 - 06:06

Aluminum scrap recycling statistics http://7d.tel/fSHBXB Economic benefits of aluminum scrap recycling

Copper scrap su... (no verificado)

Lun, 29/01/2024 - 00:18

Copper scrap product innovation http://7d.tel/XH1Kbw Copper scrap authenticity verification

Copper motor re... (no verificado)

Lun, 29/01/2024 - 15:04

Scrap copper processing http://7d.tel/NycQY0 Copper scrap advertising campaigns

Copper scrap oc... (no verificado)

Lun, 29/01/2024 - 22:16

Copper scrap sustainability reporting http://7d.tel/Px5Hf4 Copper scrap tracking

Aluminium recyc... (no verificado)

Lun, 05/02/2024 - 06:05

Scrap aluminium refurbishing http://7d.tel/9vxLZm Aluminium recycling risk management

Aluminium scrap... (no verificado)

Vie, 09/02/2024 - 14:52

Metal waste recuperation http://7d.tel/kdZ2da Collection of aluminum scrap
Scrap metal recycler, Sell aluminum cable, Scrap metal reclaiming and reprocessing

Aluminium scrap... (no verificado)

Vie, 09/02/2024 - 21:54

Scrap metal recycler http://7d.tel/zCqOZO Baling aluminum scrap
Metal salvage, Selling aluminum cable scrap, Environmental metal recycling

Scrap aluminium... (no verificado)

Sáb, 10/02/2024 - 09:32

Metal scrap recovery and recycling http://7d.tel/VTx77r Aluminium waste collection
Scrap metal recovery industry, Melting aluminum cable, Scrap metal residue

Añadir nuevo comentario

Más información sobre los formatos de texto

Filtered HTML

  • Las direcciones de las páginas web y las de correo se convierten en enlaces automáticamente.
  • Etiquetas HTML permitidas: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Saltos automáticos de líneas y de párrafos.

Plain text

  • No se permiten etiquetas HTML.
  • Las direcciones de las páginas web y las de correo se convierten en enlaces automáticamente.
  • Saltos automáticos de líneas y de párrafos.
CAPTCHA
Esta pregunta se realiza para comprobar que se trata de un humano y prevenir los accesos automatizados para publicar spam.