8 replies to this topic

[spambot]

/* Intersecção em MySql com INNER JOIN */



/* Criando banco de exemplo */



CREATE DATABASE teste;



USE teste;



/* Criando tabelas de exemplo */



CREATE TABLE tabela1 (

	id INT(11) PRIMARY KEY

);



CREATE TABLE tabela2 (

	id INT(11) PRIMARY KEY

);



CREATE TABLE tabela3  (

	id INT(11) PRIMARY KEY

);



INSERT INTO tabela1 VALUES (1);

INSERT INTO tabela1 VALUES (2);

INSERT INTO tabela1 VALUES (3);



INSERT INTO tabela2 VALUES (2);

INSERT INTO tabela2 VALUES (3);

INSERT INTO tabela2 VALUES (4);



INSERT INTO tabela3 VALUES(3);

INSERT INTO tabela3 VALUES(4);

INSERT INTO tabela3 VALUES(5);



/* Assim temos estas tabelas: */

/*

tabela1

+----+

| id |

+----+

|  1 |

|  2 |

|  3 |

+----+



tabela2

+----+

| id |

+----+

|  2 |

|  3 |

|  4 |

+----+



tabela3

+----+

| id |

+----+

|  3 |

|  4 |

|  5 |

+----+

*/



SELECT

	a.id

FROM tabela1 a

	INNER JOIN tabela2 b ON (a.id = b.id)

	INNER JOIN tabela3 c ON (a.id = c.id)

ORDER BY a.id



/*

+----+

| id |

+----+

|  3 |

+----+

*/

[HaroNism]

Para Que Sirve El Viagra Yahoo Respuestas Cialis En Jovenes Cialis Pills For Sale buy cialis Viagra 100mg 40 Amoxicillin Cat

[HaroNism]

Zithromax Alcohol Side Effects Viagra 4 Filmtbl 100 Mg viagra online Alli Tabs No Perscription Buy Propecia Hair Loss
Levitra On Line Acquistare best buy isotretinoin Cialis Mejor Que Viagra levitra 10mg Baclofen En Canada

[RonsisM]

Zithromax Loading Dose viagra Medication Cephalexin Propecia Eyebrow Growth

[Miguceamma]

Purchase Tamoxifen Online viagra Clomid Fertilite Cephalexin Pill Acne Rx Pills Com

[LarPhozyHah]

Cialis Viagra Oder Levitra Order Prescription From Canada viagra Acheter Baclofen 25mg Kamagra Preise

[HaroNism]

How To Buy Viagra Online From Canada Viagra Sin Receta En Sevilla Buying Viagra In Canada levitra 20mg Pastillas Cialis Efectos Propecia .2 Dose Keflex Clomid

[HaroNism]

Depression After Propecia Kamagra Chewable 100 Mg Canada viagra Cialis En Farmacias De Andorra Can You Take Perocet With Amoxicillin

[HaroNism]

Viagra Einnahmeempfehlung viagra Online Priligy Generic Effets Cialis Viagra
Buy No Prescription Dyazide Propecia Doping Finasteride levitra paypal accepted Acheter Priligy Generique Ou Acheter Du Levitra Pas Cher